
import pandas as pd      # Data Analysis
import numpy as np       # Mathematical Calculations
import matplotlib.pyplot as plt     # Plotting and Graphs and Charts
import seaborn as sns             # Advanced plotting (Charts in 1 line of code)
from sklearn.model_selection import train_test_split  #For spliting the data in train set and test set(ML Modeling)
from sklearn.linear_model import LogisticRegression   #Algorithm for ML model
from sklearn.metrics import accuracy_score, confusion_matrix, classification_report   #Evaluation metrics
%matplotlib inline
import warnings
warnings.filterwarnings('ignore')


!pip install openpyxl

Requirement already satisfied: openpyxl in c:\users\91858\anaconda3\lib\site-packages (3.0.9)
Requirement already satisfied: et-xmlfile in c:\users\91858\anaconda3\lib\site-packages (from openpyxl) (1.1.0)


#Setting option to show max rows and max columns
pd.set_option("display.max_columns",None)
pd.set_option("display.max_rows", None)


df=pd.read_excel('customer_retention_dataset.xlsx')
df


df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 269 entries, 0 to 268
Data columns (total 71 columns):
 #   Column                                                                                                                                                                                                          Non-Null Count  Dtype 
---  ------                                                                                                                                                                                                          --------------  ----- 
 0   1Gender of respondent                                                                                                                                                                                           269 non-null    object
 1   2 How old are you?                                                                                                                                                                                              269 non-null    object
 2   3 Which city do you shop online from?                                                                                                                                                                           269 non-null    object
 3   4 What is the Pin Code of where you shop online from?                                                                                                                                                           269 non-null    int64 
 4   5 Since How Long You are Shopping Online ?                                                                                                                                                                      269 non-null    object
 5   6 How many times you have made an online purchase in the past 1 year?                                                                                                                                           269 non-null    object
 6   7 How do you access the internet while shopping on-line?                                                                                                                                                        269 non-null    object
 7   8 Which device do you use to access the online shopping?                                                                                                                                                        269 non-null    object
 8   9 What is the screen size of your mobile device?						                                                                                                                                                          269 non-null    object
 9   10 What is the operating system (OS) of your device?				                                                                                                                                                        269 non-null    object
 10  11 What browser do you run on your device to access the website?			                                                                                                                                             269 non-null    object
 11  12 Which channel did you follow to arrive at your favorite online store for the first time?                                                                                                                     269 non-null    object
 12  13 After first visit, how do you reach the online retail store?				                                                                                                                                             269 non-null    object
 13  14 How much time do you explore the e- retail store before making a purchase decision?                                                                                                                          269 non-null    object
 14  15 What is your preferred payment Option?					                                                                                                                                                                  269 non-null    object
 15  16 How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart?							                                                                                             269 non-null    object
 16  17 Why did you abandon the “Bag”, “Shopping Cart”?					                                                                                                                                                         269 non-null    object
 17  18 The content on the website must be easy to read and understand                                                                                                                                               269 non-null    object
 18  19 Information on similar product to the one highlighted  is important for product comparison                                                                                                                   269 non-null    object
 19  20 Complete information on listed seller and product being offered is important for purchase decision.                                                                                                          269 non-null    object
 20  21 All relevant information on listed products must be stated clearly                                                                                                                                           269 non-null    object
 21  22 Ease of navigation in website                                                                                                                                                                                269 non-null    object
 22  23 Loading and processing speed                                                                                                                                                                                 269 non-null    object
 23  24 User friendly Interface of the website                                                                                                                                                                       269 non-null    object
 24  25 Convenient Payment methods                                                                                                                                                                                   269 non-null    object
 25  26 Trust that the online retail store will fulfill its part of the transaction at the stipulated time                                                                                                           269 non-null    object
 26  27 Empathy (readiness to assist with queries) towards the customers                                                                                                                                             269 non-null    object
 27  28 Being able to guarantee the privacy of the customer                                                                                                                                                          269 non-null    object
 28  29 Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.)                                                                                                      269 non-null    object
 29  30 Online shopping gives monetary benefit and discounts                                                                                                                                                         269 non-null    object
 30  31 Enjoyment is derived from shopping online                                                                                                                                                                    269 non-null    object
 31  32 Shopping online is convenient and flexible                                                                                                                                                                   269 non-null    object
 32  33 Return and replacement policy of the e-tailer is important for purchase decision                                                                                                                             269 non-null    object
 33  34 Gaining access to loyalty programs is a benefit of shopping online                                                                                                                                           269 non-null    object
 34  35 Displaying quality Information on the website improves satisfaction of customers                                                                                                                             269 non-null    object
 35  36 User derive satisfaction while shopping on a good quality website or application                                                                                                                             269 non-null    object
 36  37 Net Benefit derived from shopping online can lead to users satisfaction                                                                                                                                      269 non-null    object
 37  38 User satisfaction cannot exist without trust                                                                                                                                                                 269 non-null    object
 38  39 Offering a wide variety of listed product in several category                                                                                                                                                269 non-null    object
 39  40 Provision of complete and relevant product information                                                                                                                                                       269 non-null    object
 40  41 Monetary savings                                                                                                                                                                                             269 non-null    object
 41  42 The Convenience of patronizing the online retailer                                                                                                                                                           269 non-null    object
 42  43 Shopping on the website gives you the sense of adventure                                                                                                                                                     269 non-null    object
 43  44 Shopping on your preferred e-tailer enhances your social status                                                                                                                                              269 non-null    object
 44  45 You feel gratification shopping on your favorite e-tailer                                                                                                                                                    269 non-null    object
 45  46 Shopping on the website helps you fulfill certain roles                                                                                                                                                      269 non-null    object
 46  47 Getting value for money spent                                                                                                                                                                                269 non-null    object
 47  From the following, tick any (or all) of the online retailers you have shopped from;                                                                                                                            269 non-null    object
 48  Easy to use website or application                                                                                                                                                                              269 non-null    object
 49  Visual appealing web-page layout                                                                                                                                                                                269 non-null    object
 50  Wild variety of product on offer                                                                                                                                                                                269 non-null    object
 51  Complete, relevant description information of products                                                                                                                                                          269 non-null    object
 52  Fast loading website speed of website and application                                                                                                                                                           269 non-null    object
 53  Reliability of the website or application                                                                                                                                                                       269 non-null    object
 54  Quickness to complete purchase                                                                                                                                                                                  269 non-null    object
 55  Availability of several payment options                                                                                                                                                                         269 non-null    object
 56  Speedy order delivery                                                                                                                                                                                           269 non-null    object
 57  Privacy of customers’ information                                                                                                                                                                               269 non-null    object
 58  Security of customer financial information                                                                                                                                                                      269 non-null    object
 59  Perceived Trustworthiness                                                                                                                                                                                       269 non-null    object
 60  Presence of online assistance through multi-channel                                                                                                                                                             269 non-null    object
 61  Longer time to get logged in (promotion, sales period)                                                                                                                                                          269 non-null    object
 62  Longer time in displaying graphics and photos (promotion, sales period)                                                                                                                                         269 non-null    object
 63  Late declaration of price (promotion, sales period)                                                                                                                                                             269 non-null    object
 64  Longer page loading time (promotion, sales period)                                                                                                                                                              269 non-null    object
 65  Limited mode of payment on most products (promotion, sales period)                                                                                                                                              269 non-null    object
 66  Longer delivery period                                                                                                                                                                                          269 non-null    object
 67  Change in website/Application design                                                                                                                                                                            269 non-null    object
 68  Frequent disruption when moving from one page to another                                                                                                                                                        269 non-null    object
 69  Website is as efficient as before                                                                                                                                                                               269 non-null    object
 70  Which of the Indian online retailer would you recommend to a friend?                                                                                                                                            269 non-null    object
dtypes: int64(1), object(70)
memory usage: 149.3+ KB


df.nunique()

1Gender of respondent                                                                                                                                                                                                   2
2 How old are you?                                                                                                                                                                                                      5
3 Which city do you shop online from?                                                                                                                                                                                  11
4 What is the Pin Code of where you shop online from?                                                                                                                                                                  39
5 Since How Long You are Shopping Online ?                                                                                                                                                                              5
6 How many times you have made an online purchase in the past 1 year?                                                                                                                                                   6
7 How do you access the internet while shopping on-line?                                                                                                                                                                4
8 Which device do you use to access the online shopping?                                                                                                                                                                4
9 What is the screen size of your mobile device?\t\t\t\t\t\t                                                                                                                                                            4
10 What is the operating system (OS) of your device?\t\t\t\t                                                                                                                                                            3
11 What browser do you run on your device to access the website?\t\t\t                                                                                                                                                  4
12 Which channel did you follow to arrive at your favorite online store for the first time?                                                                                                                             3
13 After first visit, how do you reach the online retail store?\t\t\t\t                                                                                                                                                 5
14 How much time do you explore the e- retail store before making a purchase decision?                                                                                                                                  5
15 What is your preferred payment Option?\t\t\t\t\t                                                                                                                                                                     3
16 How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart?\t\t\t\t\t\t\t                                                                                              4
17 Why did you abandon the “Bag”, “Shopping Cart”?\t\t\t\t\t                                                                                                                                                            5
18 The content on the website must be easy to read and understand                                                                                                                                                       4
19 Information on similar product to the one highlighted  is important for product comparison                                                                                                                           4
20 Complete information on listed seller and product being offered is important for purchase decision.                                                                                                                  5
21 All relevant information on listed products must be stated clearly                                                                                                                                                   4
22 Ease of navigation in website                                                                                                                                                                                        4
23 Loading and processing speed                                                                                                                                                                                         5
24 User friendly Interface of the website                                                                                                                                                                               5
25 Convenient Payment methods                                                                                                                                                                                           3
26 Trust that the online retail store will fulfill its part of the transaction at the stipulated time                                                                                                                   4
27 Empathy (readiness to assist with queries) towards the customers                                                                                                                                                     4
28 Being able to guarantee the privacy of the customer                                                                                                                                                                  3
29 Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.)                                                                                                              4
30 Online shopping gives monetary benefit and discounts                                                                                                                                                                 5
31 Enjoyment is derived from shopping online                                                                                                                                                                            5
32 Shopping online is convenient and flexible                                                                                                                                                                           4
33 Return and replacement policy of the e-tailer is important for purchase decision                                                                                                                                     3
34 Gaining access to loyalty programs is a benefit of shopping online                                                                                                                                                   5
35 Displaying quality Information on the website improves satisfaction of customers                                                                                                                                     3
36 User derive satisfaction while shopping on a good quality website or application                                                                                                                                     3
37 Net Benefit derived from shopping online can lead to users satisfaction                                                                                                                                              4
38 User satisfaction cannot exist without trust                                                                                                                                                                         5
39 Offering a wide variety of listed product in several category                                                                                                                                                        4
40 Provision of complete and relevant product information                                                                                                                                                               4
41 Monetary savings                                                                                                                                                                                                     4
42 The Convenience of patronizing the online retailer                                                                                                                                                                   3
43 Shopping on the website gives you the sense of adventure                                                                                                                                                             5
44 Shopping on your preferred e-tailer enhances your social status                                                                                                                                                      5
45 You feel gratification shopping on your favorite e-tailer                                                                                                                                                            5
46 Shopping on the website helps you fulfill certain roles                                                                                                                                                              5
47 Getting value for money spent                                                                                                                                                                                        3
From the following, tick any (or all) of the online retailers you have shopped from;                                                                                                                                    9
Easy to use website or application                                                                                                                                                                                     10
Visual appealing web-page layout                                                                                                                                                                                       10
Wild variety of product on offer                                                                                                                                                                                        9
Complete, relevant description information of products                                                                                                                                                                 11
Fast loading website speed of website and application                                                                                                                                                                  10
Reliability of the website or application                                                                                                                                                                              10
Quickness to complete purchase                                                                                                                                                                                          9
Availability of several payment options                                                                                                                                                                                11
Speedy order delivery                                                                                                                                                                                                   6
Privacy of customers’ information                                                                                                                                                                                      11
Security of customer financial information                                                                                                                                                                             11
Perceived Trustworthiness                                                                                                                                                                                               9
Presence of online assistance through multi-channel                                                                                                                                                                    10
Longer time to get logged in (promotion, sales period)                                                                                                                                                                 10
Longer time in displaying graphics and photos (promotion, sales period)                                                                                                                                                10
Late declaration of price (promotion, sales period)                                                                                                                                                                     8
Longer page loading time (promotion, sales period)                                                                                                                                                                     11
Limited mode of payment on most products (promotion, sales period)                                                                                                                                                      8
Longer delivery period                                                                                                                                                                                                  6
Change in website/Application design                                                                                                                                                                                    7
Frequent disruption when moving from one page to another                                                                                                                                                                8
Website is as efficient as before                                                                                                                                                                                       8
Which of the Indian online retailer would you recommend to a friend?                                                                                                                                                    8
dtype: int64


df.isnull().any().sum()

0


#Correction in columns 
from string import digits

#Removing tab spaces
df.columns = df.columns.str.replace('\t','')

#Removing digits
remove_digits = str.maketrans('', '', digits)
df.columns = df.columns.str.translate(remove_digits)

#Removing leading and trailling spaces
df.columns = df.columns.str.strip()

df


#Looking for ambiguity in data
for i in df:
    print(i,'\n', df[i].unique())
    print('\n')

Gender of respondent 
 ['Male' 'Female']


How old are you? 
 ['31-40 years' '21-30 years' '41-50 yaers' 'Less than 20 years'
 '51 years and above']


Which city do you shop online from? 
 ['Delhi' 'Greater Noida' 'Karnal ' 'Bangalore ' 'Noida' 'Solan'
 'Moradabad' 'Gurgaon ' 'Merrut' 'Ghaziabad' 'Bulandshahr']


What is the Pin Code of where you shop online from? 
 [110009 110030 201308 132001 530068 110011 110018 173229 110039 244001
 122018 201310 560037 203207 250001 201005 110044 201306 560010 201305
 110042 132036 560018 110008 560002 201303 201312 203202 560001 201304
 560003 110014 560013 173212 122009 201009 201008 201001 203001]


Since How Long You are Shopping Online ? 
 ['Above 4 years' '3-4 years' '2-3 years' 'Less than 1 year' '1-2 years']


How many times you have made an online purchase in the past  year? 
 ['31-40 times' '41 times and above' 'Less than 10 times' '11-20 times'
 '21-30 times' '42 times and above']


How do you access the internet while shopping on-line? 
 ['Dial-up' 'Wi-Fi' 'Mobile Internet' 'Mobile internet']


Which device do you use to access the online shopping? 
 ['Desktop' 'Smartphone' 'Tablet' 'Laptop']


What is the screen size of your mobile device? 
 ['Others' '4.7 inches' '5.5 inches' '5 inches']


What is the operating system (OS) of your device? 
 ['Window/windows Mobile' 'IOS/Mac' 'Android']


What browser do you run on your device to access the website? 
 ['Google chrome' 'Safari' 'Opera' 'Mozilla Firefox']


Which channel did you follow to arrive at your favorite online store for the first time? 
 ['Search Engine' 'Content Marketing' 'Display Adverts']


After first visit, how do you reach the online retail store? 
 ['Search Engine' 'Via application' 'Direct URL' 'E-mail' 'Social Media']


How much time do you explore the e- retail store before making a purchase decision? 
 ['6-10 mins' 'more than 15 mins' '11-15 mins' '1-5 mins' 'Less than 1 min']


What is your preferred payment Option? 
 ['E-wallets (Paytm, Freecharge etc.)' 'Credit/Debit cards'
 'Cash on delivery (CoD)']


How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart? 
 ['Sometimes' 'Very frequently' 'Never' 'Frequently']


Why did you abandon the “Bag”, “Shopping Cart”? 
 ['Lack of trust' 'Promo code not applicable' 'Better alternative offer'
 'Change in price' 'No preferred mode of payment']


The content on the website must be easy to read and understand 
 ['Agree (4)' 'Strongly agree (5)' 'Strongly disagree (1)'
 'Indifferent (3)']


Information on similar product to the one highlighted  is important for product comparison 
 ['Indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)']


Complete information on listed seller and product being offered is important for purchase decision. 
 ['Indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)'
 'Strongly disagree (1)']


All relevant information on listed products must be stated clearly 
 ['Agree (4)' 'Strongly agree (5)' 'Strongly disagree (1)' 'Dis-agree (2)']


Ease of navigation in website 
 ['Agree (4)' 'Strongly agree (5)' 'Strongly disagree (1)' 'Dis-agree (2)']


Loading and processing speed 
 ['Strongly disagree (1)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)'
 'Indifferent (3)']


User friendly Interface of the website 
 ['Dis-agree (2)' 'Strongly agree (5)' 'Agree (4)' 'Strongly disagree (1)'
 'Indifferent (3)']


Convenient Payment methods 
 ['Dis-agree (2)' 'Strongly agree (5)' 'Agree (4)']


Trust that the online retail store will fulfill its part of the transaction at the stipulated time 
 ['Disagree (2)' 'Strongly agree (5)' 'Agree (4)' 'indifferent  (3)']


Empathy (readiness to assist with queries) towards the customers 
 ['Strongly agree (5)' 'Agree (4)' 'Strongly disagree (1)'
 'indifferent (3)']


Being able to guarantee the privacy of the customer 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)']


Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.) 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)'
 'Strongly disagree (1)']


Online shopping gives monetary benefit and discounts 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)'
 'Strongly disagree (1)' 'Dis-agree (2)']


Enjoyment is derived from shopping online 
 ['Strongly disagree (1)' 'Strongly agree (5)' 'indifferent (3)'
 'Agree (4)' 'Dis-agree (2)']


Shopping online is convenient and flexible 
 ['Dis-agree (2)' 'Strongly agree (5)' 'indifferent (3)' 'Agree (4)']


Return and replacement policy of the e-tailer is important for purchase decision 
 ['Dis-agree (2)' 'Strongly agree (5)' 'Agree (4)']


Gaining access to loyalty programs is a benefit of shopping online 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)' 'Dis-agree (2)'
 'Strongly disagree (1)']


Displaying quality Information on the website improves satisfaction of customers 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)']


User derive satisfaction while shopping on a good quality website or application 
 ['Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)']


Net Benefit derived from shopping online can lead to users satisfaction 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)' 'Dis-agree (2)']


User satisfaction cannot exist without trust 
 ['Strongly agree (5)' 'Agree (4)' 'Strongly disagree (1)' 'Dis-agree (2)'
 'indifferent (3)']


Offering a wide variety of listed product in several category 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)']


Provision of complete and relevant product information 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Disagree (2)']


Monetary savings 
 ['Disagree (2)' 'Strongly agree (5)' 'Agree (4)' 'indifferent (3)']


The Convenience of patronizing the online retailer 
 ['indifferent (3)' 'Agree (4)' 'Strongly agree (5)']


Shopping on the website gives you the sense of adventure 
 ['Agree (4)' 'indifferent (3)' 'Strongly agree (5)' 'Dis-agree (2)'
 'Strongly disagree (1)']


Shopping on your preferred e-tailer enhances your social status 
 ['Agree (4)' 'indifferent (3)' 'Strongly agree (5)'
 'Strongly disagree (1)' 'Dis-agree (2)']


You feel gratification shopping on your favorite e-tailer 
 ['Strongly agree (5)' 'indifferent (3)' 'Agree (4)'
 'Strongly disagree (1)' 'Disagree (2)']


Shopping on the website helps you fulfill certain roles 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)'
 'Strongly disagree (1)' 'Dis-agree (2)']


Getting value for money spent 
 ['Strongly agree (5)' 'Agree (4)' 'indifferent (3)']


From the following, tick any (or all) of the online retailers you have shopped from; 
 ['Amazon.in, Paytm.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in' 'Amazon.in, Flipkart.com, Paytm.com']


Easy to use website or application 
 ['Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in' 'Amazon.in, Paytm.com' 'Flipkart.com']


Visual appealing web-page layout 
 ['Flipkart.com' 'Amazon.in, Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Myntra.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Flipkart.com, Myntra.com' 'Amazon.in']


Wild variety of product on offer 
 ['Flipkart.com' 'Flipkart.com, Myntra.com' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com' 'Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Paytm.com']


Complete, relevant description information of products 
 ['Snapdeal.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com, Myntra.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Flipkart.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Flipkart.com']


Fast loading website speed of website and application 
 ['Snapdeal.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Flipkart.com']


Reliability of the website or application 
 ['Paytm.com' 'Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Flipkart.com']


Quickness to complete purchase 
 ['Paytm.com' 'Amazon.com, Flipkart.com, Myntra.com'
 'Amazon.com, Paytm.com, Myntra.com' 'Amazon.com, Flipkart.com, Paytm.com'
 'Amazon.com, Flipkart.com, Paytm.com, Myntra.com, Snapdeal' 'Amazon.com'
 'Flipkart.com, Myntra.com, Snapdeal' 'Amazon.com, Flipkart.com'
 'Flipkart.com']


Availability of several payment options 
 ['Patym.com' 'Amazon.in, Flipkart.com, Myntra.com' 'Patym.com, Myntra.com'
 'Amazon.in, Flipkart.com, Patym.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Amazon.in, Flipkart.com'
 'Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in, Patym.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in'
 'Flipkart.com']


Speedy order delivery 
 ['Amazon.in' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Myntra.com' 'Flipkart.com']


Privacy of customers’ information 
 ['Amazon.in' 'Myntra.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Flipkart.com']


Security of customer financial information 
 ['Amazon.in' 'Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Flipkart.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Snapdeal.com']


Perceived Trustworthiness 
 ['Flipkart.com' 'Myntra.com' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com']


Presence of online assistance through multi-channel 
 ['Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com' 'Myntra.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Amazon.in'
 'Amazon.in, Flipkart.com' 'Amazon.in, Snapdeal' 'Flipkart.com']


Longer time to get logged in (promotion, sales period) 
 ['Amazon.in' 'Amazon.in, Flipkart.com' 'Myntra.com' 'Snapdeal.com'
 'Flipkart.com, Paytm.com' 'Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Flipkart.com']


Longer time in displaying graphics and photos (promotion, sales period) 
 ['Amazon.in' 'Myntra.com' 'Myntra.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Myntra.com, Snapdeal.com' 'Flipkart.com, Snapdeal.com'
 'Snapdeal.com' 'Flipkart.com']


Late declaration of price (promotion, sales period) 
 ['Flipkart.com' 'snapdeal.com' 'Myntra.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in' 'Paytm.com, snapdeal.com'
 'Amazon.in, Flipkart.com']


Longer page loading time (promotion, sales period) 
 ['Flipkart.com' 'Snapdeal.com' 'Myntra.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Snapdeal.com' 'Flipkart.com, Snapdeal.com'
 'Paytm.com, Snapdeal.com' 'Amazon.in' 'Amazon.in, Paytm.com, Myntra.com']


Limited mode of payment on most products (promotion, sales period) 
 ['Amazon.in' 'Snapdeal.com' 'Paytm.com' 'Amazon.in, Paytm.com'
 'Flipkart.com' 'Amazon.in, Flipkart.com' 'Paytm.com, Snapdeal.com'
 'Myntra.com, Snapdeal.com']


Longer delivery period 
 ['Paytm.com' 'Snapdeal.com' 'Flipkart.com' 'Amazon.in'
 'Paytm.com, Snapdeal.com' 'Myntra.com']


Change in website/Application design 
 ['Flipkart.com' 'Amazon.in' 'Paytm.com' 'Amazon.in, Flipkart.com'
 'Myntra.com' 'Snapdeal.com' 'Flipkart.com, Myntra.com']


Frequent disruption when moving from one page to another 
 ['Amazon.in' 'Myntra.com' 'Paytm.com' 'Amazon.in, Flipkart.com'
 'Snapdeal.com' 'Flipkart.com' 'Myntra.com, Snapdeal.com'
 'Flipkart.com, Snapdeal.com']


Website is as efficient as before 
 ['Amazon.in' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Paytm.com' 'Snapdeal.com'
 'Myntra.com, Snapdeal.com' 'Flipkart.com' 'Amazon.in, Paytm.com']


Which of the Indian online retailer would you recommend to a friend? 
 ['Flipkart.com' 'Amazon.in, Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Paytm.com'
 'Flipkart.com, Paytm.com, Myntra.com, snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com']


#Resolving ambiguity of column 
#Changing 42 times and above to 41 times and above as there are two unique seperate value for both
df['How many times you have made an online purchase in the past  year?'].replace('42 times and above','41 times and above',
                                                                                 inplace=True)


#Changing Mobile internet to Mobile Internet as there are two unique seperate value for both
df['How do you access the internet while shopping on-line?'].replace('Mobile internet','Mobile Internet',
                                                                                 inplace=True)

#Changing Greater noida to noida as there are two unique seperate value for both
df['Which city do you shop online from?'].replace({'Greater Noida':'Noida'},inplace=True)


#Checking if more ambiguity left in data
for i in df:
    print(i,'\n', df[i].unique())
    print('\n')

Gender of respondent 
 ['Male' 'Female']


How old are you? 
 ['31-40 years' '21-30 years' '41-50 yaers' 'Less than 20 years'
 '51 years and above']


Which city do you shop online from? 
 ['Delhi' 'Noida' 'Karnal ' 'Bangalore ' 'Solan' 'Moradabad' 'Gurgaon '
 'Merrut' 'Ghaziabad' 'Bulandshahr']


What is the Pin Code of where you shop online from? 
 [110009 110030 201308 132001 530068 110011 110018 173229 110039 244001
 122018 201310 560037 203207 250001 201005 110044 201306 560010 201305
 110042 132036 560018 110008 560002 201303 201312 203202 560001 201304
 560003 110014 560013 173212 122009 201009 201008 201001 203001]


Since How Long You are Shopping Online ? 
 ['Above 4 years' '3-4 years' '2-3 years' 'Less than 1 year' '1-2 years']


How many times you have made an online purchase in the past  year? 
 ['31-40 times' '41 times and above' 'Less than 10 times' '11-20 times'
 '21-30 times']


How do you access the internet while shopping on-line? 
 ['Dial-up' 'Wi-Fi' 'Mobile Internet']


Which device do you use to access the online shopping? 
 ['Desktop' 'Smartphone' 'Tablet' 'Laptop']


What is the screen size of your mobile device? 
 ['Others' '4.7 inches' '5.5 inches' '5 inches']


What is the operating system (OS) of your device? 
 ['Window/windows Mobile' 'IOS/Mac' 'Android']


What browser do you run on your device to access the website? 
 ['Google chrome' 'Safari' 'Opera' 'Mozilla Firefox']


Which channel did you follow to arrive at your favorite online store for the first time? 
 ['Search Engine' 'Content Marketing' 'Display Adverts']


After first visit, how do you reach the online retail store? 
 ['Search Engine' 'Via application' 'Direct URL' 'E-mail' 'Social Media']


How much time do you explore the e- retail store before making a purchase decision? 
 ['6-10 mins' 'more than 15 mins' '11-15 mins' '1-5 mins' 'Less than 1 min']


What is your preferred payment Option? 
 ['E-wallets (Paytm, Freecharge etc.)' 'Credit/Debit cards'
 'Cash on delivery (CoD)']


How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart? 
 ['Sometimes' 'Very frequently' 'Never' 'Frequently']


Why did you abandon the “Bag”, “Shopping Cart”? 
 ['Lack of trust' 'Promo code not applicable' 'Better alternative offer'
 'Change in price' 'No preferred mode of payment']


The content on the website must be easy to read and understand 
 ['Agree (4)' 'Strongly agree (5)' 'Strongly disagree (1)'
 'Indifferent (3)']


Information on similar product to the one highlighted  is important for product comparison 
 ['Indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)']


Complete information on listed seller and product being offered is important for purchase decision. 
 ['Indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)'
 'Strongly disagree (1)']


All relevant information on listed products must be stated clearly 
 ['Agree (4)' 'Strongly agree (5)' 'Strongly disagree (1)' 'Dis-agree (2)']


Ease of navigation in website 
 ['Agree (4)' 'Strongly agree (5)' 'Strongly disagree (1)' 'Dis-agree (2)']


Loading and processing speed 
 ['Strongly disagree (1)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)'
 'Indifferent (3)']


User friendly Interface of the website 
 ['Dis-agree (2)' 'Strongly agree (5)' 'Agree (4)' 'Strongly disagree (1)'
 'Indifferent (3)']


Convenient Payment methods 
 ['Dis-agree (2)' 'Strongly agree (5)' 'Agree (4)']


Trust that the online retail store will fulfill its part of the transaction at the stipulated time 
 ['Disagree (2)' 'Strongly agree (5)' 'Agree (4)' 'indifferent  (3)']


Empathy (readiness to assist with queries) towards the customers 
 ['Strongly agree (5)' 'Agree (4)' 'Strongly disagree (1)'
 'indifferent (3)']


Being able to guarantee the privacy of the customer 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)']


Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.) 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)'
 'Strongly disagree (1)']


Online shopping gives monetary benefit and discounts 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)'
 'Strongly disagree (1)' 'Dis-agree (2)']


Enjoyment is derived from shopping online 
 ['Strongly disagree (1)' 'Strongly agree (5)' 'indifferent (3)'
 'Agree (4)' 'Dis-agree (2)']


Shopping online is convenient and flexible 
 ['Dis-agree (2)' 'Strongly agree (5)' 'indifferent (3)' 'Agree (4)']


Return and replacement policy of the e-tailer is important for purchase decision 
 ['Dis-agree (2)' 'Strongly agree (5)' 'Agree (4)']


Gaining access to loyalty programs is a benefit of shopping online 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)' 'Dis-agree (2)'
 'Strongly disagree (1)']


Displaying quality Information on the website improves satisfaction of customers 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)']


User derive satisfaction while shopping on a good quality website or application 
 ['Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)']


Net Benefit derived from shopping online can lead to users satisfaction 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)' 'Dis-agree (2)']


User satisfaction cannot exist without trust 
 ['Strongly agree (5)' 'Agree (4)' 'Strongly disagree (1)' 'Dis-agree (2)'
 'indifferent (3)']


Offering a wide variety of listed product in several category 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Dis-agree (2)']


Provision of complete and relevant product information 
 ['indifferent (3)' 'Strongly agree (5)' 'Agree (4)' 'Disagree (2)']


Monetary savings 
 ['Disagree (2)' 'Strongly agree (5)' 'Agree (4)' 'indifferent (3)']


The Convenience of patronizing the online retailer 
 ['indifferent (3)' 'Agree (4)' 'Strongly agree (5)']


Shopping on the website gives you the sense of adventure 
 ['Agree (4)' 'indifferent (3)' 'Strongly agree (5)' 'Dis-agree (2)'
 'Strongly disagree (1)']


Shopping on your preferred e-tailer enhances your social status 
 ['Agree (4)' 'indifferent (3)' 'Strongly agree (5)'
 'Strongly disagree (1)' 'Dis-agree (2)']


You feel gratification shopping on your favorite e-tailer 
 ['Strongly agree (5)' 'indifferent (3)' 'Agree (4)'
 'Strongly disagree (1)' 'Disagree (2)']


Shopping on the website helps you fulfill certain roles 
 ['Agree (4)' 'Strongly agree (5)' 'indifferent (3)'
 'Strongly disagree (1)' 'Dis-agree (2)']


Getting value for money spent 
 ['Strongly agree (5)' 'Agree (4)' 'indifferent (3)']


From the following, tick any (or all) of the online retailers you have shopped from; 
 ['Amazon.in, Paytm.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in' 'Amazon.in, Flipkart.com, Paytm.com']


Easy to use website or application 
 ['Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in' 'Amazon.in, Paytm.com' 'Flipkart.com']


Visual appealing web-page layout 
 ['Flipkart.com' 'Amazon.in, Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Myntra.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Flipkart.com, Myntra.com' 'Amazon.in']


Wild variety of product on offer 
 ['Flipkart.com' 'Flipkart.com, Myntra.com' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com' 'Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Paytm.com']


Complete, relevant description information of products 
 ['Snapdeal.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com, Myntra.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Flipkart.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Flipkart.com']


Fast loading website speed of website and application 
 ['Snapdeal.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Flipkart.com']


Reliability of the website or application 
 ['Paytm.com' 'Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Flipkart.com']


Quickness to complete purchase 
 ['Paytm.com' 'Amazon.com, Flipkart.com, Myntra.com'
 'Amazon.com, Paytm.com, Myntra.com' 'Amazon.com, Flipkart.com, Paytm.com'
 'Amazon.com, Flipkart.com, Paytm.com, Myntra.com, Snapdeal' 'Amazon.com'
 'Flipkart.com, Myntra.com, Snapdeal' 'Amazon.com, Flipkart.com'
 'Flipkart.com']


Availability of several payment options 
 ['Patym.com' 'Amazon.in, Flipkart.com, Myntra.com' 'Patym.com, Myntra.com'
 'Amazon.in, Flipkart.com, Patym.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Amazon.in, Flipkart.com'
 'Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in, Patym.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in'
 'Flipkart.com']


Speedy order delivery 
 ['Amazon.in' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Myntra.com' 'Flipkart.com']


Privacy of customers’ information 
 ['Amazon.in' 'Myntra.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Flipkart.com']


Security of customer financial information 
 ['Amazon.in' 'Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Flipkart.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Snapdeal.com']


Perceived Trustworthiness 
 ['Flipkart.com' 'Myntra.com' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com']


Presence of online assistance through multi-channel 
 ['Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com' 'Myntra.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Amazon.in'
 'Amazon.in, Flipkart.com' 'Amazon.in, Snapdeal' 'Flipkart.com']


Longer time to get logged in (promotion, sales period) 
 ['Amazon.in' 'Amazon.in, Flipkart.com' 'Myntra.com' 'Snapdeal.com'
 'Flipkart.com, Paytm.com' 'Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Flipkart.com']


Longer time in displaying graphics and photos (promotion, sales period) 
 ['Amazon.in' 'Myntra.com' 'Myntra.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Myntra.com, Snapdeal.com' 'Flipkart.com, Snapdeal.com'
 'Snapdeal.com' 'Flipkart.com']


Late declaration of price (promotion, sales period) 
 ['Flipkart.com' 'snapdeal.com' 'Myntra.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in' 'Paytm.com, snapdeal.com'
 'Amazon.in, Flipkart.com']


Longer page loading time (promotion, sales period) 
 ['Flipkart.com' 'Snapdeal.com' 'Myntra.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Snapdeal.com' 'Flipkart.com, Snapdeal.com'
 'Paytm.com, Snapdeal.com' 'Amazon.in' 'Amazon.in, Paytm.com, Myntra.com']


Limited mode of payment on most products (promotion, sales period) 
 ['Amazon.in' 'Snapdeal.com' 'Paytm.com' 'Amazon.in, Paytm.com'
 'Flipkart.com' 'Amazon.in, Flipkart.com' 'Paytm.com, Snapdeal.com'
 'Myntra.com, Snapdeal.com']


Longer delivery period 
 ['Paytm.com' 'Snapdeal.com' 'Flipkart.com' 'Amazon.in'
 'Paytm.com, Snapdeal.com' 'Myntra.com']


Change in website/Application design 
 ['Flipkart.com' 'Amazon.in' 'Paytm.com' 'Amazon.in, Flipkart.com'
 'Myntra.com' 'Snapdeal.com' 'Flipkart.com, Myntra.com']


Frequent disruption when moving from one page to another 
 ['Amazon.in' 'Myntra.com' 'Paytm.com' 'Amazon.in, Flipkart.com'
 'Snapdeal.com' 'Flipkart.com' 'Myntra.com, Snapdeal.com'
 'Flipkart.com, Snapdeal.com']


Website is as efficient as before 
 ['Amazon.in' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Paytm.com' 'Snapdeal.com'
 'Myntra.com, Snapdeal.com' 'Flipkart.com' 'Amazon.in, Paytm.com']


Which of the Indian online retailer would you recommend to a friend? 
 ['Flipkart.com' 'Amazon.in, Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Paytm.com'
 'Flipkart.com, Paytm.com, Myntra.com, snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com']


#Columns 1 to 17 are personal info or personal question, so we will make different 
#dataset for these columns
personal=df.iloc[:,0:17]

#Columns 18 to 47 are feedback questions or suggestions, so we will make different 
#dataset for these columns
feedbacks=df.iloc[:,17:47]

#Columns 49 to 61 are good attributes of website, so we will make different 
#dataset for these columns
good_attribute=df.iloc[:,48:61]


#Columns 62 to 70 are bad attributes of website, so we will make different 
#dataset for these columns
bad_attribute=df.iloc[:,61:70]


personal.head()


feedbacks.head()


good_attribute.head()


bad_attribute.head()


for i in personal:
    plt.figure(figsize=(6,6))
    df[i].value_counts().plot.pie(autopct='%.2f%%')
    #centre=plt.Circle((0,0),0.8,fc='white')
    #fig=plt.gcf()
    #fig.gca().add_artist(centre)
    plt.xlabel(i)
    plt.ylabel('')
    plt.figure()

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>


# People participated in survey according to Gender and Age
plt.figure(figsize=(10,8))
sns.countplot(personal['How old are you?'],hue=personal['Gender of respondent'])

<AxesSubplot:xlabel='How old are you?', ylabel='count'>


# Number of times shoping done (Gender wise)
plt.figure(figsize=(10,8))
sns.countplot(personal['How many times you have made an online purchase in the past  year?'],hue=personal['Gender of respondent'])

<AxesSubplot:xlabel='How many times you have made an online purchase in the past  year?', ylabel='count'>


# Number of times shoping done (According to age)
plt.figure(figsize=(10,8))
sns.countplot(personal['How many times you have made an online purchase in the past  year?'],hue=personal['How old are you?'])

<AxesSubplot:xlabel='How many times you have made an online purchase in the past  year?', ylabel='count'>


# Number of years customer has been shoping (According to age)
plt.figure(figsize=(10,8))
sns.countplot(personal['Since How Long You are Shopping Online ?'],hue=personal['How old are you?'])

<AxesSubplot:xlabel='Since How Long You are Shopping Online ?', ylabel='count'>


for i in feedbacks:
    plt.figure(figsize=(6,6))
    df[i].value_counts().plot.pie(autopct='%.2f%%')
    #centre=plt.Circle((0,0),0.8,fc='white')
    #fig=plt.gcf()
    #fig.gca().add_artist(centre)
    plt.xlabel(i)
    plt.ylabel('')
    plt.figure()

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>


for i in good_attribute:
    plt.figure(figsize=(6,6))
    df[i].value_counts().plot.pie(autopct='%.2f%%')
    #centre=plt.Circle((0,0),0.8,fc='white')
    #fig=plt.gcf()
    #fig.gca().add_artist(centre)
    plt.xlabel(i)
    plt.ylabel('')
    plt.figure()

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>


for i in bad_attribute:
    plt.figure(figsize=(6,6))
    df[i].value_counts().plot.pie(autopct='%.2f%%')
    #centre=plt.Circle((0,0),0.8,fc='white')
    #fig=plt.gcf()
    #fig.gca().add_artist(centre)
    plt.xlabel(i)
    plt.ylabel('')
    plt.figure()

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>

<Figure size 432x288 with 0 Axes>


plt.figure(figsize=(12,10))
sns.stripplot(df['Why did you abandon the “Bag”, “Shopping Cart”?'],
              df['From the following, tick any (or all) of the online retailers you have shopped from;'])

<AxesSubplot:xlabel='Why did you abandon the “Bag”, “Shopping Cart”?', ylabel='From the following, tick any (or all) of the online retailers you have shopped from;'>


# Replacing 'Strongly disagree (1)','Dis-agree (2)','Indifferent (3)','Agree (4)','Strongly agree (5)' with 1,2,3,4,5

df.replace(['Strongly disagree (1)','Dis-agree (2)','Indifferent (3)','Agree (4)','Strongly agree (5)'], [1,2,3,4,5], inplace=True)

df


# As 'Disagree (2)','indifferent (3)' are not yet replaced we will replaec them as well

df.replace(['Disagree (2)','indifferent (3)'], [2,3], inplace=True)

df


# checking whether all value has been changed or not
for i in df:
    print(i,'\n', df[i].unique())
    print('\n')

Gender of respondent 
 ['Male' 'Female']


How old are you? 
 ['31-40 years' '21-30 years' '41-50 yaers' 'Less than 20 years'
 '51 years and above']


Which city do you shop online from? 
 ['Delhi' 'Noida' 'Karnal ' 'Bangalore ' 'Solan' 'Moradabad' 'Gurgaon '
 'Merrut' 'Ghaziabad' 'Bulandshahr']


What is the Pin Code of where you shop online from? 
 [110009 110030 201308 132001 530068 110011 110018 173229 110039 244001
 122018 201310 560037 203207 250001 201005 110044 201306 560010 201305
 110042 132036 560018 110008 560002 201303 201312 203202 560001 201304
 560003 110014 560013 173212 122009 201009 201008 201001 203001]


Since How Long You are Shopping Online ? 
 ['Above 4 years' '3-4 years' '2-3 years' 'Less than 1 year' '1-2 years']


How many times you have made an online purchase in the past  year? 
 ['31-40 times' '41 times and above' 'Less than 10 times' '11-20 times'
 '21-30 times']


How do you access the internet while shopping on-line? 
 ['Dial-up' 'Wi-Fi' 'Mobile Internet']


Which device do you use to access the online shopping? 
 ['Desktop' 'Smartphone' 'Tablet' 'Laptop']


What is the screen size of your mobile device? 
 ['Others' '4.7 inches' '5.5 inches' '5 inches']


What is the operating system (OS) of your device? 
 ['Window/windows Mobile' 'IOS/Mac' 'Android']


What browser do you run on your device to access the website? 
 ['Google chrome' 'Safari' 'Opera' 'Mozilla Firefox']


Which channel did you follow to arrive at your favorite online store for the first time? 
 ['Search Engine' 'Content Marketing' 'Display Adverts']


After first visit, how do you reach the online retail store? 
 ['Search Engine' 'Via application' 'Direct URL' 'E-mail' 'Social Media']


How much time do you explore the e- retail store before making a purchase decision? 
 ['6-10 mins' 'more than 15 mins' '11-15 mins' '1-5 mins' 'Less than 1 min']


What is your preferred payment Option? 
 ['E-wallets (Paytm, Freecharge etc.)' 'Credit/Debit cards'
 'Cash on delivery (CoD)']


How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart? 
 ['Sometimes' 'Very frequently' 'Never' 'Frequently']


Why did you abandon the “Bag”, “Shopping Cart”? 
 ['Lack of trust' 'Promo code not applicable' 'Better alternative offer'
 'Change in price' 'No preferred mode of payment']


The content on the website must be easy to read and understand 
 [4 5 1 3]


Information on similar product to the one highlighted  is important for product comparison 
 [3 5 4 2]


Complete information on listed seller and product being offered is important for purchase decision. 
 [3 5 4 2 1]


All relevant information on listed products must be stated clearly 
 [4 5 1 2]


Ease of navigation in website 
 [4 5 1 2]


Loading and processing speed 
 [1 5 4 2 3]


User friendly Interface of the website 
 [2 5 4 1 3]


Convenient Payment methods 
 [2 5 4]


Trust that the online retail store will fulfill its part of the transaction at the stipulated time 
 [2 5 4 'indifferent  (3)']


Empathy (readiness to assist with queries) towards the customers 
 [5 4 1 3]


Being able to guarantee the privacy of the customer 
 [4 5 3]


Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.) 
 [4 5 3 1]


Online shopping gives monetary benefit and discounts 
 [3 5 4 1 2]


Enjoyment is derived from shopping online 
 [1 5 3 4 2]


Shopping online is convenient and flexible 
 [2 5 3 4]


Return and replacement policy of the e-tailer is important for purchase decision 
 [2 5 4]


Gaining access to loyalty programs is a benefit of shopping online 
 [4 5 3 2 1]


Displaying quality Information on the website improves satisfaction of customers 
 [3 5 4]


User derive satisfaction while shopping on a good quality website or application 
 [5 4 2]


Net Benefit derived from shopping online can lead to users satisfaction 
 [4 5 3 2]


User satisfaction cannot exist without trust 
 [5 4 1 2 3]


Offering a wide variety of listed product in several category 
 [3 5 4 2]


Provision of complete and relevant product information 
 [3 5 4 2]


Monetary savings 
 [2 5 4 3]


The Convenience of patronizing the online retailer 
 [3 4 5]


Shopping on the website gives you the sense of adventure 
 [4 3 5 2 1]


Shopping on your preferred e-tailer enhances your social status 
 [4 3 5 1 2]


You feel gratification shopping on your favorite e-tailer 
 [5 3 4 1 2]


Shopping on the website helps you fulfill certain roles 
 [4 5 3 1 2]


Getting value for money spent 
 [5 4 3]


From the following, tick any (or all) of the online retailers you have shopped from; 
 ['Amazon.in, Paytm.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in' 'Amazon.in, Flipkart.com, Paytm.com']


Easy to use website or application 
 ['Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in' 'Amazon.in, Paytm.com' 'Flipkart.com']


Visual appealing web-page layout 
 ['Flipkart.com' 'Amazon.in, Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Myntra.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Flipkart.com, Myntra.com' 'Amazon.in']


Wild variety of product on offer 
 ['Flipkart.com' 'Flipkart.com, Myntra.com' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com' 'Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Paytm.com']


Complete, relevant description information of products 
 ['Snapdeal.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com, Myntra.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Flipkart.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Flipkart.com']


Fast loading website speed of website and application 
 ['Snapdeal.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Flipkart.com']


Reliability of the website or application 
 ['Paytm.com' 'Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Flipkart.com']


Quickness to complete purchase 
 ['Paytm.com' 'Amazon.com, Flipkart.com, Myntra.com'
 'Amazon.com, Paytm.com, Myntra.com' 'Amazon.com, Flipkart.com, Paytm.com'
 'Amazon.com, Flipkart.com, Paytm.com, Myntra.com, Snapdeal' 'Amazon.com'
 'Flipkart.com, Myntra.com, Snapdeal' 'Amazon.com, Flipkart.com'
 'Flipkart.com']


Availability of several payment options 
 ['Patym.com' 'Amazon.in, Flipkart.com, Myntra.com' 'Patym.com, Myntra.com'
 'Amazon.in, Flipkart.com, Patym.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Amazon.in, Flipkart.com'
 'Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in, Patym.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com' 'Amazon.in'
 'Flipkart.com']


Speedy order delivery 
 ['Amazon.in' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Myntra.com' 'Flipkart.com']


Privacy of customers’ information 
 ['Amazon.in' 'Myntra.com' 'Amazon.in, Flipkart.com, Myntra.com'
 'Amazon.in, Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Flipkart.com']


Security of customer financial information 
 ['Amazon.in' 'Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Flipkart.com' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com'
 'Amazon.in, Snapdeal.com']


Perceived Trustworthiness 
 ['Flipkart.com' 'Myntra.com' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Paytm.com, Myntra.com, Snapdeal.com'
 'Amazon.in' 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Flipkart.com, Paytm.com']


Presence of online assistance through multi-channel 
 ['Paytm.com' 'Amazon.in, Flipkart.com, Myntra.com' 'Myntra.com'
 'Amazon.in, Flipkart.com, Myntra.com, Snapdeal' 'Amazon.in, Myntra.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Amazon.in'
 'Amazon.in, Flipkart.com' 'Amazon.in, Snapdeal' 'Flipkart.com']


Longer time to get logged in (promotion, sales period) 
 ['Amazon.in' 'Amazon.in, Flipkart.com' 'Myntra.com' 'Snapdeal.com'
 'Flipkart.com, Paytm.com' 'Flipkart.com, Paytm.com, Snapdeal.com'
 'Amazon.in, Flipkart.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Flipkart.com']


Longer time in displaying graphics and photos (promotion, sales period) 
 ['Amazon.in' 'Myntra.com' 'Myntra.com, Snapdeal.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Myntra.com, Snapdeal.com' 'Flipkart.com, Snapdeal.com'
 'Snapdeal.com' 'Flipkart.com']


Late declaration of price (promotion, sales period) 
 ['Flipkart.com' 'snapdeal.com' 'Myntra.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in' 'Paytm.com, snapdeal.com'
 'Amazon.in, Flipkart.com']


Longer page loading time (promotion, sales period) 
 ['Flipkart.com' 'Snapdeal.com' 'Myntra.com' 'Paytm.com'
 'Amazon.in, Paytm.com' 'Amazon.in, Flipkart.com'
 'Amazon.in, Snapdeal.com' 'Flipkart.com, Snapdeal.com'
 'Paytm.com, Snapdeal.com' 'Amazon.in' 'Amazon.in, Paytm.com, Myntra.com']


Limited mode of payment on most products (promotion, sales period) 
 ['Amazon.in' 'Snapdeal.com' 'Paytm.com' 'Amazon.in, Paytm.com'
 'Flipkart.com' 'Amazon.in, Flipkart.com' 'Paytm.com, Snapdeal.com'
 'Myntra.com, Snapdeal.com']


Longer delivery period 
 ['Paytm.com' 'Snapdeal.com' 'Flipkart.com' 'Amazon.in'
 'Paytm.com, Snapdeal.com' 'Myntra.com']


Change in website/Application design 
 ['Flipkart.com' 'Amazon.in' 'Paytm.com' 'Amazon.in, Flipkart.com'
 'Myntra.com' 'Snapdeal.com' 'Flipkart.com, Myntra.com']


Frequent disruption when moving from one page to another 
 ['Amazon.in' 'Myntra.com' 'Paytm.com' 'Amazon.in, Flipkart.com'
 'Snapdeal.com' 'Flipkart.com' 'Myntra.com, Snapdeal.com'
 'Flipkart.com, Snapdeal.com']


Website is as efficient as before 
 ['Amazon.in' 'Amazon.in, Flipkart.com'
 'Amazon.in, Flipkart.com, Paytm.com' 'Paytm.com' 'Snapdeal.com'
 'Myntra.com, Snapdeal.com' 'Flipkart.com' 'Amazon.in, Paytm.com']


Which of the Indian online retailer would you recommend to a friend? 
 ['Flipkart.com' 'Amazon.in, Myntra.com' 'Amazon.in, Paytm.com, Myntra.com'
 'Amazon.in, Flipkart.com' 'Amazon.in, Paytm.com'
 'Flipkart.com, Paytm.com, Myntra.com, snapdeal.com' 'Amazon.in'
 'Amazon.in, Flipkart.com, Myntra.com']


# 'indifferent  (3)' was left so changing it as well
df.replace(['indifferent  (3)'], [3], inplace=True)


# Encoding gender column
df['Gender of respondent'].replace(['Male', 'Female'], [0,1], inplace=True)


x=df.drop('Which of the Indian online retailer would you recommend to a friend?',axis=1)
y=df['Which of the Indian online retailer would you recommend to a friend?']


cat_columns=[i for i in x.columns if x[i].dtypes=='O']


from sklearn.preprocessing import OrdinalEncoder,LabelEncoder
ordinal=OrdinalEncoder()
labe=LabelEncoder()

#using ordinal encoder for independent features
for i in cat:
    x[i]=ordinal.fit_transform(x[i].values.reshape(-1,1))

#Using label encoder for target Column
y=labe.fit_transform(y)

x


# checking unique value of x
for i in x:
    print(i,'\n', x[i].unique())
    print('\n')

Gender of respondent 
 [0 1]


How old are you? 
 [1. 0. 2. 4. 3.]


Which city do you shop online from? 
 [2. 8. 5. 0. 9. 7. 4. 6. 3. 1.]


What is the Pin Code of where you shop online from? 
 [110009 110030 201308 132001 530068 110011 110018 173229 110039 244001
 122018 201310 560037 203207 250001 201005 110044 201306 560010 201305
 110042 132036 560018 110008 560002 201303 201312 203202 560001 201304
 560003 110014 560013 173212 122009 201009 201008 201001 203001]


Since How Long You are Shopping Online ? 
 [3. 2. 1. 4. 0.]


How many times you have made an online purchase in the past  year? 
 [2. 3. 4. 0. 1.]


How do you access the internet while shopping on-line? 
 [0. 2. 1.]


Which device do you use to access the online shopping? 
 [0. 2. 3. 1.]


What is the screen size of your mobile device? 
 [3. 0. 2. 1.]


What is the operating system (OS) of your device? 
 [2. 1. 0.]


What browser do you run on your device to access the website? 
 [0. 3. 2. 1.]


Which channel did you follow to arrive at your favorite online store for the first time? 
 [2. 0. 1.]


After first visit, how do you reach the online retail store? 
 [2. 4. 0. 1. 3.]


How much time do you explore the e- retail store before making a purchase decision? 
 [2. 4. 1. 0. 3.]


What is your preferred payment Option? 
 [2. 1. 0.]


How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart? 
 [2. 3. 1. 0.]


Why did you abandon the “Bag”, “Shopping Cart”? 
 [2. 4. 0. 1. 3.]


The content on the website must be easy to read and understand 
 [4 5 1 3]


Information on similar product to the one highlighted  is important for product comparison 
 [3 5 4 2]


Complete information on listed seller and product being offered is important for purchase decision. 
 [3 5 4 2 1]


All relevant information on listed products must be stated clearly 
 [4 5 1 2]


Ease of navigation in website 
 [4 5 1 2]


Loading and processing speed 
 [1 5 4 2 3]


User friendly Interface of the website 
 [2 5 4 1 3]


Convenient Payment methods 
 [2 5 4]


Trust that the online retail store will fulfill its part of the transaction at the stipulated time 
 [2 5 4 3]


Empathy (readiness to assist with queries) towards the customers 
 [5 4 1 3]


Being able to guarantee the privacy of the customer 
 [4 5 3]


Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.) 
 [4 5 3 1]


Online shopping gives monetary benefit and discounts 
 [3 5 4 1 2]


Enjoyment is derived from shopping online 
 [1 5 3 4 2]


Shopping online is convenient and flexible 
 [2 5 3 4]


Return and replacement policy of the e-tailer is important for purchase decision 
 [2 5 4]


Gaining access to loyalty programs is a benefit of shopping online 
 [4 5 3 2 1]


Displaying quality Information on the website improves satisfaction of customers 
 [3 5 4]


User derive satisfaction while shopping on a good quality website or application 
 [5 4 2]


Net Benefit derived from shopping online can lead to users satisfaction 
 [4 5 3 2]


User satisfaction cannot exist without trust 
 [5 4 1 2 3]


Offering a wide variety of listed product in several category 
 [3 5 4 2]


Provision of complete and relevant product information 
 [3 5 4 2]


Monetary savings 
 [2 5 4 3]


The Convenience of patronizing the online retailer 
 [3 4 5]


Shopping on the website gives you the sense of adventure 
 [4 3 5 2 1]


Shopping on your preferred e-tailer enhances your social status 
 [4 3 5 1 2]


You feel gratification shopping on your favorite e-tailer 
 [5 3 4 1 2]


Shopping on the website helps you fulfill certain roles 
 [4 5 3 1 2]


Getting value for money spent 
 [5 4 3]


From the following, tick any (or all) of the online retailers you have shopped from; 
 [7. 2. 8. 4. 5. 1. 6. 0. 3.]


Easy to use website or application 
 [9. 3. 7. 4. 5. 1. 2. 0. 6. 8.]


Visual appealing web-page layout 
 [7. 5. 6. 3. 9. 1. 2. 4. 8. 0.]


Wild variety of product on offer 
 [5. 6. 4. 1. 7. 3. 0. 2. 8.]


Complete, relevant description information of products 
 [10.  2.  7.  1.  5.  4.  9.  3.  0.  6.  8.]


Fast loading website speed of website and application 
 [9. 2. 7. 6. 0. 5. 4. 3. 1. 8.]


Reliability of the website or application 
 [9. 8. 6. 3. 4. 5. 0. 2. 1. 7.]


Quickness to complete purchase 
 [8. 2. 5. 3. 4. 0. 7. 1. 6.]


Availability of several payment options 
 [ 9.  2. 10.  4.  5.  1.  8.  6.  3.  0.  7.]


Speedy order delivery 
 [0. 1. 3. 5. 2. 4.]


Privacy of customers’ information 
 [ 0.  9.  2.  7.  5. 10.  3.  1.  4.  6.  8.]


Security of customer financial information 
 [ 0.  9.  6.  5. 10.  4.  8.  2.  1.  3.  7.]


Perceived Trustworthiness 
 [7. 8. 6. 5. 4. 0. 2. 1. 3.]


Presence of online assistance through multi-channel 
 [9. 2. 8. 3. 5. 4. 0. 1. 6. 7.]


Longer time to get logged in (promotion, sales period) 
 [0. 1. 7. 9. 5. 6. 2. 8. 3. 4.]


Longer time in displaying graphics and photos (promotion, sales period) 
 [0. 6. 7. 8. 3. 1. 2. 5. 9. 4.]


Late declaration of price (promotion, sales period) 
 [3. 7. 4. 5. 2. 0. 6. 1.]


Longer page loading time (promotion, sales period) 
 [ 5. 10.  7.  8.  2.  1.  4.  6.  9.  0.  3.]


Limited mode of payment on most products (promotion, sales period) 
 [0. 7. 5. 2. 3. 1. 6. 4.]


Longer delivery period 
 [3. 5. 1. 0. 4. 2.]


Change in website/Application design 
 [2. 0. 5. 1. 4. 6. 3.]


Frequent disruption when moving from one page to another 
 [0. 4. 6. 1. 7. 2. 5. 3.]


Website is as efficient as before 
 [0. 1. 2. 6. 7. 5. 4. 3.]


# Droping the pin code column
x=x.drop('What is the Pin Code of where you shop online from?',axis=1)

x


from sklearn.preprocessing import MinMaxScaler,StandardScaler
scaler=MinMaxScaler()

xd=scaler.fit_transform(x)
x=pd.DataFrame(xd,columns=x.columns)

x


# Getting the best random stae value
logmodel = LogisticRegression()
for i in range(0,10):
    x_train,x_test,y_train,y_test=train_test_split(x,y, test_size=0.2, random_state=i)
    logmodel.fit(x_train,y_train)
    pred_train=logmodel.predict(x_train)
    pred_test=logmodel.predict(x_test) 
    if (accuracy_score(y_train,pred_train)*100>80 and accuracy_score(y_test,pred_test)*100>80):
                      print("At random state", i ,"the training accuracy is", accuracy_score(y_train,pred_train))
                      print("At random state", i ,"the test accuracy is", accuracy_score(y_test,pred_test))
                      print("\n")

At random state 0 the training accuracy is 1.0
At random state 0 the test accuracy is 1.0


At random state 1 the training accuracy is 1.0
At random state 1 the test accuracy is 1.0


At random state 2 the training accuracy is 1.0
At random state 2 the test accuracy is 1.0


At random state 3 the training accuracy is 1.0
At random state 3 the test accuracy is 1.0


At random state 4 the training accuracy is 1.0
At random state 4 the test accuracy is 0.9814814814814815


At random state 5 the training accuracy is 1.0
At random state 5 the test accuracy is 1.0


At random state 6 the training accuracy is 1.0
At random state 6 the test accuracy is 1.0


At random state 7 the training accuracy is 1.0
At random state 7 the test accuracy is 1.0


At random state 8 the training accuracy is 1.0
At random state 8 the test accuracy is 1.0


At random state 9 the training accuracy is 1.0
At random state 9 the test accuracy is 1.0


#Spliting the data into test and train set
x_train,x_test,y_train,y_test=train_test_split(x,y, test_size=0.2, random_state=2)
print(x.shape,x_train.shape,x_test.shape)

(269, 69) (215, 69) (54, 69)


logmodel.fit(x_train,y_train)
pred_test=logmodel.predict(x_test)
print(accuracy_score(y_test,pred_test))
print(confusion_matrix(y_test,pred_test))
print(classification_report(y_test,pred_test))

1.0
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  0  2  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0  0  0  0  0  0 11  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       1.00      1.00      1.00        12
           2       1.00      1.00      1.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       1.00      1.00      1.00        11
           7       1.00      1.00      1.00         3

    accuracy                           1.00        54
   macro avg       1.00      1.00      1.00        54
weighted avg       1.00      1.00      1.00        54


from sklearn.model_selection import cross_val_score


# cross validation of LogisticRegression(logmodel) model
cv_score=cross_val_score(logmodel,x,y)
cv_mean=cv_score.mean()
print(f"cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test)-cv_mean)

cv score is 0.9962962962962962
Difference between accuracy and validation score 0.0037037037037037646


from sklearn.ensemble import GradientBoostingClassifier, AdaBoostClassifier, BaggingClassifier
from sklearn.ensemble import RandomForestClassifier, ExtraTreesClassifier


rfc=RandomForestClassifier()
rfc.fit(x_train,y_train)

pred_test_rfc=rfc.predict(x_test)
print(accuracy_score(y_test,pred_test_rfc))
print(confusion_matrix(y_test,pred_test_rfc))
print(classification_report(y_test,pred_test_rfc))

1.0
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  0  2  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0  0  0  0  0  0 11  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       1.00      1.00      1.00        12
           2       1.00      1.00      1.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       1.00      1.00      1.00        11
           7       1.00      1.00      1.00         3

    accuracy                           1.00        54
   macro avg       1.00      1.00      1.00        54
weighted avg       1.00      1.00      1.00        54


# cross validation of RandomForestClassifier model
cv_score=cross_val_score(rfc,x,y)
cv_mean=cv_score.mean()
print(f"cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test_rfc)-cv_mean)

cv score is 1.0
Difference between accuracy and validation score 0.0


gb=GradientBoostingClassifier()
gb.fit(x_train,y_train)
pred_test_gb=gb.predict(x_test)
print(accuracy_score(y_test,pred_test_gb))
print(confusion_matrix(y_test,pred_test_gb))
print(classification_report(y_test,pred_test_gb))

1.0
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  0  2  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0  0  0  0  0  0 11  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       1.00      1.00      1.00        12
           2       1.00      1.00      1.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       1.00      1.00      1.00        11
           7       1.00      1.00      1.00         3

    accuracy                           1.00        54
   macro avg       1.00      1.00      1.00        54
weighted avg       1.00      1.00      1.00        54


# cross validation of GradientBoostingClassifier model
cv_score=cross_val_score(gb,x,y)
cv_mean=cv_score.mean()
print(f"cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test_gb)-cv_mean)

cv score is 1.0
Difference between accuracy and validation score 0.0


ada=AdaBoostClassifier()
ada.fit(x_train,y_train)
pred_test_ada=ada.predict(x_test)
print(accuracy_score(y_test,pred_test_ada))
print(confusion_matrix(y_test,pred_test_ada))
print(classification_report(y_test,pred_test_ada))

0.7592592592592593
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  2  0  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0 11  0  0  0  0  0  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       0.48      1.00      0.65        12
           2       0.00      0.00      0.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       0.00      0.00      0.00        11
           7       1.00      1.00      1.00         3

    accuracy                           0.76        54
   macro avg       0.69      0.75      0.71        54
weighted avg       0.64      0.76      0.68        54


# cross validation of AdaBoostClassifier model
cv_score=cross_val_score(ada,x,y,cv=6)
cv_mean=cv_score.mean()
print(f"cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test_ada)-cv_mean)

cv score is 0.7956228956228957
Difference between accuracy and validation score -0.036363636363636376


bag=BaggingClassifier()
bag.fit(x_train,y_train)
pred_test_bag=bag.predict(x_test)
print(accuracy_score(y_test,pred_test_bag))
print(confusion_matrix(y_test,pred_test_bag))
print(classification_report(y_test,pred_test_bag))

1.0
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  0  2  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0  0  0  0  0  0 11  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       1.00      1.00      1.00        12
           2       1.00      1.00      1.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       1.00      1.00      1.00        11
           7       1.00      1.00      1.00         3

    accuracy                           1.00        54
   macro avg       1.00      1.00      1.00        54
weighted avg       1.00      1.00      1.00        54


# cross validation of BaggingClassifier model
cv_score=cross_val_score(bag,x,y,cv=6)
cv_mean=cv_score.mean()
print(f"the cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test_bag)-cv_mean)

the cv score is 1.0
Difference between accuracy and validation score 0.0


etc=ExtraTreesClassifier()
etc.fit(x_train,y_train)
pred_test_etc=etc.predict(x_test)
print(accuracy_score(y_test,pred_test_etc))
print(confusion_matrix(y_test,pred_test_etc))
print(classification_report(y_test,pred_test_etc))

1.0
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  0  2  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0  0  0  0  0  0 11  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       1.00      1.00      1.00        12
           2       1.00      1.00      1.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       1.00      1.00      1.00        11
           7       1.00      1.00      1.00         3

    accuracy                           1.00        54
   macro avg       1.00      1.00      1.00        54
weighted avg       1.00      1.00      1.00        54


# cross validation of ExtraTreesClassifier model
cv_score=cross_val_score(etc,x,y,cv=6)
cv_mean=cv_score.mean()
print(f"The cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test_etc)-cv_mean)

The cv score is 1.0
Difference between accuracy and validation score 0.0


from sklearn.svm import SVC
svc=SVC()
svc.fit(x_train,y_train)
pred_test_svc=svc.predict(x_test)
print(accuracy_score(y_test,pred_test_svc))
print(confusion_matrix(y_test,pred_test_svc))
print(classification_report(y_test,pred_test_svc))

1.0
[[14  0  0  0  0  0  0  0]
 [ 0 12  0  0  0  0  0  0]
 [ 0  0  2  0  0  0  0  0]
 [ 0  0  0  9  0  0  0  0]
 [ 0  0  0  0  2  0  0  0]
 [ 0  0  0  0  0  1  0  0]
 [ 0  0  0  0  0  0 11  0]
 [ 0  0  0  0  0  0  0  3]]
              precision    recall  f1-score   support

           0       1.00      1.00      1.00        14
           1       1.00      1.00      1.00        12
           2       1.00      1.00      1.00         2
           3       1.00      1.00      1.00         9
           4       1.00      1.00      1.00         2
           5       1.00      1.00      1.00         1
           6       1.00      1.00      1.00        11
           7       1.00      1.00      1.00         3

    accuracy                           1.00        54
   macro avg       1.00      1.00      1.00        54
weighted avg       1.00      1.00      1.00        54


# cross validation of RandomForestClassifier model
cv_score=cross_val_score(svc,x,y,cv=6)
cv_mean=cv_score.mean()
print(f"The cv score is {cv_mean}")
print('Difference between accuracy and validation score', accuracy_score(y_test,pred_test_svc)-cv_mean)

The cv score is 1.0
Difference between accuracy and validation score 0.0


from sklearn.model_selection import RandomizedSearchCV

parameters={
    
    "max_depth":[3,5,8],
    "max_features":["auto", "sqrt", "log2"],
    "criterion":["gini", "entropy"],
    "n_estimators":[50,100,150]
    }


clf=RandomizedSearchCV(RandomForestClassifier(),parameters)
clf.fit(x_train, y_train)
print(clf.best_params_)

{'n_estimators': 150, 'max_features': 'auto', 'max_depth': 5, 'criterion': 'gini'}


Tuned_model=RandomForestClassifier(n_estimators= 150, max_features='auto', max_depth= 5, criterion= 'gini')
Tuned_model.fit(x_train, y_train)
results=Tuned_model.predict(x_test)
print(accuracy_score(y_test,results)*100)

100.0


As our all the model have 100% accuracy, we can select and save any of the model.


import pickle
filename='customer_retention.pkl'
pickle.dump(Tuned_model, open(filename,'wb'))

Import dependencies¶

Exploratory Data Analysis¶

Data Cleaning¶

Data Segmentation¶

Data Visualisation¶

Visualisation For personal segment data¶

Visualisation For 'feedbacks' segment data¶

Visualisation For 'Good_attribute' segment data¶

Visualisation For 'bad_attribute' segment data¶

Why did people abandon their bag¶

Data Preprocessing¶

ML Modeling¶

Ensemble Technique¶

Tuning¶

Finalising and Model Saving¶

Conclusion¶

	Gender of respondent	How old are you?	Which city do you shop online from?	What is the Pin Code of where you shop online from?	Since How Long You are Shopping Online ?	How many times you have made an online purchase in the past year?	How do you access the internet while shopping on-line?	Which device do you use to access the online shopping?	What is the screen size of your mobile device?	What is the operating system (OS) of your device?	What browser do you run on your device to access the website?	Which channel did you follow to arrive at your favorite online store for the first time?	After first visit, how do you reach the online retail store?	How much time do you explore the e- retail store before making a purchase decision?	What is your preferred payment Option?	How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart?	Why did you abandon the “Bag”, “Shopping Cart”?
0	Male	31-40 years	Delhi	110009	Above 4 years	31-40 times	Dial-up	Desktop	Others	Window/windows Mobile	Google chrome	Search Engine	Search Engine	6-10 mins	E-wallets (Paytm, Freecharge etc.)	Sometimes	Lack of trust
1	Female	21-30 years	Delhi	110030	Above 4 years	41 times and above	Wi-Fi	Smartphone	4.7 inches	IOS/Mac	Google chrome	Search Engine	Via application	more than 15 mins	Credit/Debit cards	Very frequently	Promo code not applicable
2	Female	21-30 years	Noida	201308	3-4 years	41 times and above	Mobile Internet	Smartphone	5.5 inches	Android	Google chrome	Search Engine	Via application	11-15 mins	E-wallets (Paytm, Freecharge etc.)	Sometimes	Promo code not applicable
3	Male	21-30 years	Karnal	132001	3-4 years	Less than 10 times	Mobile Internet	Smartphone	5.5 inches	IOS/Mac	Safari	Search Engine	Search Engine	6-10 mins	Credit/Debit cards	Never	Better alternative offer
4	Female	21-30 years	Bangalore	530068	2-3 years	11-20 times	Wi-Fi	Smartphone	4.7 inches	IOS/Mac	Safari	Content Marketing	Via application	more than 15 mins	Credit/Debit cards	Frequently	Better alternative offer

	The content on the website must be easy to read and understand	Information on similar product to the one highlighted is important for product comparison	Complete information on listed seller and product being offered is important for purchase decision.	All relevant information on listed products must be stated clearly	Ease of navigation in website	Loading and processing speed	User friendly Interface of the website	Convenient Payment methods	Trust that the online retail store will fulfill its part of the transaction at the stipulated time	Empathy (readiness to assist with queries) towards the customers	Being able to guarantee the privacy of the customer	Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.)	Online shopping gives monetary benefit and discounts	Enjoyment is derived from shopping online	Shopping online is convenient and flexible	Return and replacement policy of the e-tailer is important for purchase decision	Gaining access to loyalty programs is a benefit of shopping online	Displaying quality Information on the website improves satisfaction of customers	User derive satisfaction while shopping on a good quality website or application	Net Benefit derived from shopping online can lead to users satisfaction	User satisfaction cannot exist without trust	Offering a wide variety of listed product in several category	Provision of complete and relevant product information	Monetary savings	The Convenience of patronizing the online retailer	Shopping on the website gives you the sense of adventure	Shopping on your preferred e-tailer enhances your social status	You feel gratification shopping on your favorite e-tailer	Shopping on the website helps you fulfill certain roles	Getting value for money spent
0	Agree (4)	Indifferent (3)	Indifferent (3)	Agree (4)	Agree (4)	Strongly disagree (1)	Dis-agree (2)	Dis-agree (2)	Disagree (2)	Strongly agree (5)	Agree (4)	Agree (4)	indifferent (3)	Strongly disagree (1)	Dis-agree (2)	Dis-agree (2)	Agree (4)	indifferent (3)	Strongly agree (5)	Agree (4)	Strongly agree (5)	indifferent (3)	indifferent (3)	Disagree (2)	indifferent (3)	Agree (4)	Agree (4)	Strongly agree (5)	Agree (4)	Strongly agree (5)
1	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	indifferent (3)	indifferent (3)	indifferent (3)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)
2	Strongly agree (5)	Agree (4)	Agree (4)	Agree (4)	Agree (4)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Agree (4)	Agree (4)	Agree (4)	indifferent (3)	indifferent (3)	Agree (4)
3	Agree (4)	Agree (4)	Indifferent (3)	Agree (4)	Strongly agree (5)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Agree (4)	Agree (4)	indifferent (3)	indifferent (3)	Agree (4)	indifferent (3)	indifferent (3)	Agree (4)	indifferent (3)	Agree (4)	Agree (4)	Agree (4)	Strongly agree (5)	Agree (4)	Agree (4)	Strongly agree (5)	Agree (4)	indifferent (3)	Agree (4)
4	Strongly agree (5)	Indifferent (3)	Indifferent (3)	Agree (4)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Agree (4)	Strongly agree (5)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Dis-agree (2)	Agree (4)	Strongly agree (5)	Strongly agree (5)	Strongly agree (5)	Agree (4)	Agree (4)	Strongly agree (5)	Agree (4)	indifferent (3)	Strongly disagree (1)	Strongly agree (5)	Strongly disagree (1)	Strongly agree (5)

	Easy to use website or application	Visual appealing web-page layout	Wild variety of product on offer	Complete, relevant description information of products	Fast loading website speed of website and application	Reliability of the website or application	Quickness to complete purchase	Availability of several payment options	Speedy order delivery	Privacy of customers’ information	Security of customer financial information	Perceived Trustworthiness	Presence of online assistance through multi-channel
0	Paytm.com	Flipkart.com	Flipkart.com	Snapdeal.com	Snapdeal.com	Paytm.com	Paytm.com	Patym.com	Amazon.in	Amazon.in	Amazon.in	Flipkart.com	Paytm.com
1	Amazon.in, Flipkart.com, Myntra.com, Snapdeal.com	Amazon.in, Myntra.com	Flipkart.com, Myntra.com	Amazon.in, Flipkart.com, Myntra.com	Amazon.in, Flipkart.com, Myntra.com	Myntra.com	Amazon.com, Flipkart.com, Myntra.com	Amazon.in, Flipkart.com, Myntra.com	Amazon.in, Flipkart.com	Myntra.com	Myntra.com	Myntra.com	Amazon.in, Flipkart.com, Myntra.com
2	Amazon.in, Paytm.com, Myntra.com	Amazon.in, Paytm.com, Myntra.com	Amazon.in, Myntra.com	Amazon.in, Paytm.com, Myntra.com	Amazon.in, Paytm.com	Amazon.in, Paytm.com, Myntra.com	Amazon.com, Paytm.com, Myntra.com	Patym.com, Myntra.com	Amazon.in	Amazon.in	Amazon.in, Paytm.com, Myntra.com	Amazon.in, Myntra.com	Myntra.com
3	Amazon.in, Flipkart.com, Paytm.com, Myntra.com...	Amazon.in, Flipkart.com, Paytm.com, Myntra.com...	Amazon.in, Flipkart.com	Amazon.in, Flipkart.com	Amazon.in, Flipkart.com, Snapdeal.com	Amazon.in, Flipkart.com, Paytm.com	Amazon.com, Flipkart.com, Paytm.com	Amazon.in, Flipkart.com, Myntra.com	Amazon.in, Flipkart.com, Snapdeal.com	Amazon.in, Flipkart.com, Myntra.com	Amazon.in, Flipkart.com, Snapdeal.com	Amazon.in, Flipkart.com, Snapdeal.com	Amazon.in, Flipkart.com, Myntra.com, Snapdeal
4	Amazon.in, Flipkart.com, Paytm.com, Myntra.com...	Myntra.com	Myntra.com	Amazon.in, Flipkart.com, Paytm.com, Myntra.com...	Amazon.in	Amazon.in, Paytm.com, Myntra.com	Amazon.com, Flipkart.com, Paytm.com, Myntra.co...	Amazon.in, Flipkart.com, Patym.com, Myntra.com...	Amazon.in	Amazon.in, Paytm.com	Paytm.com	Amazon.in, Myntra.com	Amazon.in, Myntra.com

	Gender of respondent	How old are you?	Which city do you shop online from?	What is the Pin Code of where you shop online from?	Since How Long You are Shopping Online ?	How many times you have made an online purchase in the past year?	How do you access the internet while shopping on-line?	Which device do you use to access the online shopping?	What is the screen size of your mobile device?	What is the operating system (OS) of your device?	What browser do you run on your device to access the website?	Which channel did you follow to arrive at your favorite online store for the first time?	After first visit, how do you reach the online retail store?	How much time do you explore the e- retail store before making a purchase decision?	What is your preferred payment Option?	How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart?	Why did you abandon the “Bag”, “Shopping Cart”?	The content on the website must be easy to read and understand	Information on similar product to the one highlighted is important for product comparison	Complete information on listed seller and product being offered is important for purchase decision.	All relevant information on listed products must be stated clearly	Ease of navigation in website	Loading and processing speed	User friendly Interface of the website	Convenient Payment methods	Trust that the online retail store will fulfill its part of the transaction at the stipulated time	Empathy (readiness to assist with queries) towards the customers	Being able to guarantee the privacy of the customer	Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.)	Online shopping gives monetary benefit and discounts	Enjoyment is derived from shopping online	Shopping online is convenient and flexible	Return and replacement policy of the e-tailer is important for purchase decision	Gaining access to loyalty programs is a benefit of shopping online	Displaying quality Information on the website improves satisfaction of customers	User derive satisfaction while shopping on a good quality website or application	Net Benefit derived from shopping online can lead to users satisfaction	User satisfaction cannot exist without trust	Offering a wide variety of listed product in several category	Provision of complete and relevant product information	Monetary savings	The Convenience of patronizing the online retailer	Shopping on the website gives you the sense of adventure	Shopping on your preferred e-tailer enhances your social status	You feel gratification shopping on your favorite e-tailer	Shopping on the website helps you fulfill certain roles	Getting value for money spent	From the following, tick any (or all) of the online retailers you have shopped from;	Easy to use website or application	Visual appealing web-page layout	Wild variety of product on offer	Complete, relevant description information of products	Fast loading website speed of website and application	Reliability of the website or application	Quickness to complete purchase	Availability of several payment options	Speedy order delivery	Privacy of customers’ information	Security of customer financial information	Perceived Trustworthiness	Presence of online assistance through multi-channel	Longer time to get logged in (promotion, sales period)	Longer time in displaying graphics and photos (promotion, sales period)	Late declaration of price (promotion, sales period)	Longer page loading time (promotion, sales period)	Limited mode of payment on most products (promotion, sales period)	Longer delivery period	Change in website/Application design	Frequent disruption when moving from one page to another	Website is as efficient as before
0	0	1.0	2.0	110009	3.0	2.0	0.0	0.0	3.0	2.0	0.0	2.0	2.0	2.0	2.0	2.0	2.0	4	3	3	4	4	1	2	2	2	5	4	4	3	1	2	2	4	3	5	4	5	3	3	2	3	4	4	5	4	5	7.0	9.0	7.0	5.0	10.0	9.0	9.0	8.0	9.0	0.0	0.0	0.0	7.0	9.0	0.0	0.0	3.0	5.0	0.0	3.0	2.0	0.0	0.0
1	1	0.0	2.0	110030	3.0	3.0	2.0	2.0	0.0	1.0	0.0	2.0	4.0	4.0	1.0	3.0	4.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	3	5	5	5	2.0	3.0	5.0	6.0	2.0	2.0	8.0	2.0	2.0	1.0	9.0	9.0	8.0	2.0	1.0	6.0	7.0	10.0	7.0	5.0	0.0	4.0	1.0
2	1	0.0	8.0	201308	2.0	3.0	1.0	2.0	2.0	0.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
3	0	0.0	5.0	132001	2.0	4.0	1.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
4	1	0.0	0.0	530068	1.0	0.0	2.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
5	1	1.0	8.0	201308	3.0	3.0	2.0	2.0	2.0	0.0	0.0	2.0	4.0	4.0	2.0	0.0	0.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	4	5	4.0	4.0	1.0	3.0	4.0	7.0	4.0	8.0	4.0	0.0	5.0	4.0	4.0	4.0	6.0	3.0	2.0	2.0	2.0	1.0	5.0	2.0	0.0
6	0	2.0	2.0	110011	3.0	2.0	2.0	3.0	3.0	0.0	0.0	1.0	0.0	4.0	1.0	2.0	4.0	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	5	5	4	4	4	4	4	3	4	4	3	3	4	4	4	5.0	5.0	3.0	0.0	9.0	5.0	5.0	3.0	5.0	3.0	5.0	4.0	5.0	3.0	2.0	0.0	4.0	7.0	3.0	5.0	4.0	4.0	7.0
7	0	2.0	2.0	110018	2.0	4.0	1.0	0.0	3.0	2.0	0.0	2.0	1.0	2.0	1.0	2.0	1.0	1	2	2	1	1	2	1	2	2	1	3	5	1	1	5	5	5	5	5	4	1	5	5	5	5	5	1	1	1	4	4.0	1.0	1.0	1.0	1.0	4.0	0.0	0.0	1.0	0.0	10.0	8.0	0.0	0.0	1.0	1.0	5.0	1.0	1.0	1.0	0.0	0.0	0.0
8	1	4.0	9.0	173229	1.0	4.0	2.0	2.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	3.0	5	4	5	4	4	4	5	5	5	5	5	5	5	4	5	4	4	5	5	5	5	5	4	4	4	4	3	3	4	3	2.0	3.0	2.0	2.0	3.0	3.0	2.0	7.0	8.0	5.0	3.0	2.0	2.0	3.0	0.0	2.0	0.0	4.0	0.0	0.0	0.0	5.0	5.0
9	1	1.0	2.0	110039	4.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	2.0	4.0	0.0	2.0	2.0	4	5	4	4	5	5	5	4	5	5	5	5	4	4	4	5	4	4	4	5	4	4	4	4	4	4	3	3	3	4	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	8.0	1.0	5.0	8.0	7.0	5.0	4.0	4.0	4.0
10	0	1.0	7.0	244001	3.0	1.0	1.0	1.0	3.0	2.0	0.0	2.0	0.0	2.0	1.0	2.0	1.0	5	3	4	5	4	5	4	4	5	4	5	4	2	3	4	5	1	3	4	2	5	3	4	2	3	4	2	2	4	3	5.0	5.0	4.0	1.0	4.0	7.0	3.0	3.0	6.0	1.0	4.0	3.0	3.0	0.0	3.0	1.0	3.0	6.0	1.0	4.0	0.0	3.0	3.0
11	1	2.0	8.0	201308	3.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	4	5	5	4	5	4	4	5	5	5	3	2	5	5	4	5	5	5	4	3	5	5	3	2	4	4	3	4	6.0	2.0	1.0	1.0	0.0	5.0	0.0	0.0	3.0	1.0	1.0	7.0	0.0	6.0	8.0	5.0	4.0	7.0	7.0	2.0	5.0	6.0	1.0
12	1	3.0	4.0	122018	1.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	5	5	5	5	5	5	5	5	5	3	4	4	4	5	5	5	5	5	5	5	5	3	4	2	3	3	2	4	2.0	3.0	8.0	1.0	1.0	2.0	1.0	2.0	1.0	2.0	0.0	0.0	0.0	1.0	7.0	9.0	7.0	9.0	6.0	4.0	1.0	7.0	4.0
13	1	1.0	8.0	201310	3.0	0.0	2.0	1.0	3.0	2.0	0.0	2.0	2.0	1.0	1.0	2.0	0.0	5	5	1	5	5	5	5	5	5	5	5	1	3	3	5	5	3	5	5	5	5	4	5	4	4	3	2	2	4	5	4.0	4.0	1.0	1.0	1.0	1.0	1.0	1.0	4.0	1.0	1.0	4.0	2.0	3.0	2.0	9.0	7.0	7.0	7.0	5.0	5.0	7.0	1.0
14	1	0.0	5.0	132001	4.0	3.0	2.0	2.0	2.0	0.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
15	1	0.0	0.0	560037	1.0	3.0	1.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
16	0	1.0	8.0	201308	0.0	1.0	1.0	1.0	3.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
17	0	2.0	2.0	110011	4.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	4.0	4.0	2.0	0.0	0.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	4	5	4.0	4.0	1.0	3.0	4.0	7.0	4.0	8.0	4.0	0.0	5.0	4.0	4.0	4.0	6.0	3.0	2.0	2.0	2.0	1.0	5.0	2.0	0.0
18	1	2.0	2.0	110018	0.0	4.0	2.0	1.0	3.0	2.0	0.0	1.0	0.0	4.0	1.0	2.0	4.0	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	5	5	4	4	4	4	4	3	4	4	3	3	4	4	4	5.0	5.0	3.0	0.0	9.0	5.0	5.0	3.0	5.0	3.0	5.0	4.0	5.0	3.0	2.0	0.0	4.0	7.0	3.0	5.0	4.0	4.0	7.0
19	1	0.0	9.0	173229	0.0	0.0	2.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
20	1	0.0	8.0	201308	0.0	3.0	2.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
21	0	1.0	4.0	122018	2.0	2.0	2.0	3.0	1.0	0.0	0.0	2.0	1.0	2.0	1.0	2.0	1.0	1	2	2	1	1	2	1	2	2	1	3	5	1	1	5	5	5	5	5	4	1	5	5	5	5	5	1	1	1	4	4.0	1.0	1.0	1.0	1.0	4.0	0.0	0.0	1.0	0.0	10.0	8.0	0.0	0.0	1.0	1.0	5.0	1.0	1.0	1.0	0.0	0.0	0.0
22	0	2.0	8.0	201310	3.0	2.0	1.0	3.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	3.0	5	4	5	4	4	4	5	5	5	5	5	5	5	4	5	4	4	5	5	5	5	5	4	4	4	4	3	3	4	3	2.0	3.0	2.0	2.0	3.0	3.0	2.0	7.0	8.0	5.0	3.0	2.0	2.0	3.0	0.0	2.0	0.0	4.0	0.0	0.0	0.0	5.0	5.0
23	1	2.0	8.0	203207	3.0	3.0	1.0	0.0	3.0	2.0	0.0	2.0	2.0	4.0	0.0	2.0	2.0	4	5	4	4	5	5	5	4	5	5	5	5	4	4	4	5	4	4	4	5	4	4	4	4	4	4	3	3	3	4	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	8.0	1.0	5.0	8.0	7.0	5.0	4.0	4.0	4.0
24	1	0.0	6.0	250001	2.0	3.0	1.0	2.0	1.0	2.0	0.0	2.0	0.0	2.0	1.0	2.0	1.0	5	3	4	5	4	5	4	4	5	4	5	4	2	3	4	5	1	3	4	2	5	3	4	2	3	4	2	2	4	3	5.0	5.0	4.0	1.0	4.0	7.0	3.0	3.0	6.0	1.0	4.0	3.0	3.0	0.0	3.0	1.0	3.0	6.0	1.0	4.0	0.0	3.0	3.0
25	1	0.0	0.0	530068	1.0	4.0	1.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	4	5	5	4	5	4	4	5	5	5	3	2	5	5	4	5	5	5	4	3	5	5	3	2	4	4	3	4	6.0	2.0	1.0	1.0	0.0	5.0	0.0	0.0	3.0	1.0	1.0	7.0	0.0	6.0	8.0	5.0	4.0	7.0	7.0	2.0	5.0	6.0	1.0
26	0	0.0	3.0	201005	4.0	0.0	1.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	5	5	5	5	5	5	5	5	5	3	4	4	4	5	5	5	5	5	5	5	5	3	4	2	3	3	2	4	2.0	3.0	8.0	1.0	1.0	2.0	1.0	2.0	1.0	2.0	0.0	0.0	0.0	1.0	7.0	9.0	7.0	9.0	6.0	4.0	1.0	7.0	4.0
27	0	1.0	2.0	110044	3.0	3.0	1.0	1.0	3.0	2.0	0.0	2.0	2.0	1.0	1.0	2.0	0.0	5	5	1	5	5	5	5	5	5	5	5	1	3	3	5	5	3	5	5	5	5	4	5	4	4	3	2	2	4	5	4.0	4.0	1.0	1.0	1.0	1.0	1.0	1.0	4.0	1.0	1.0	4.0	2.0	3.0	2.0	9.0	7.0	7.0	7.0	5.0	5.0	7.0	1.0
28	1	2.0	8.0	201306	3.0	2.0	1.0	1.0	3.0	2.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
29	1	2.0	5.0	132001	1.0	4.0	1.0	1.0	3.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
30	1	4.0	0.0	560010	3.0	4.0	1.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
31	0	1.0	8.0	201305	1.0	4.0	1.0	0.0	3.0	2.0	0.0	2.0	2.0	2.0	2.0	2.0	2.0	4	3	3	4	4	1	2	2	2	5	4	4	3	1	2	2	4	3	5	4	5	3	3	2	3	4	4	5	4	5	7.0	9.0	7.0	5.0	10.0	9.0	9.0	8.0	9.0	0.0	0.0	0.0	7.0	9.0	0.0	0.0	3.0	5.0	0.0	3.0	2.0	0.0	0.0
32	0	1.0	2.0	110042	3.0	1.0	1.0	2.0	0.0	1.0	0.0	2.0	4.0	4.0	1.0	3.0	4.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	3	5	5	5	2.0	3.0	5.0	6.0	2.0	2.0	8.0	2.0	2.0	1.0	9.0	9.0	8.0	2.0	1.0	6.0	7.0	10.0	7.0	5.0	0.0	4.0	1.0
33	1	2.0	8.0	201308	3.0	4.0	1.0	2.0	2.0	0.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
34	1	3.0	5.0	132036	2.0	4.0	1.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
35	1	0.0	0.0	560018	1.0	0.0	1.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
36	0	1.0	8.0	201305	4.0	4.0	1.0	2.0	2.0	0.0	0.0	2.0	4.0	4.0	2.0	0.0	0.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	4	5	4.0	4.0	1.0	3.0	4.0	7.0	4.0	8.0	4.0	0.0	5.0	4.0	4.0	4.0	6.0	3.0	2.0	2.0	2.0	1.0	5.0	2.0	0.0
37	0	2.0	2.0	110008	3.0	0.0	1.0	3.0	3.0	0.0	0.0	1.0	0.0	4.0	1.0	2.0	4.0	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	5	5	4	4	4	4	4	3	4	4	3	3	4	4	4	5.0	5.0	3.0	0.0	9.0	5.0	5.0	3.0	5.0	3.0	5.0	4.0	5.0	3.0	2.0	0.0	4.0	7.0	3.0	5.0	4.0	4.0	7.0
38	1	2.0	8.0	201308	3.0	3.0	1.0	0.0	3.0	2.0	0.0	2.0	1.0	2.0	1.0	2.0	1.0	1	2	2	1	1	2	1	2	2	1	3	5	1	1	5	5	5	5	5	4	1	5	5	5	5	5	1	1	1	4	4.0	1.0	1.0	1.0	1.0	4.0	0.0	0.0	1.0	0.0	10.0	8.0	0.0	0.0	1.0	1.0	5.0	1.0	1.0	1.0	0.0	0.0	0.0
39	1	0.0	5.0	132036	1.0	2.0	1.0	2.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	3.0	5	4	5	4	4	4	5	5	5	5	5	5	5	4	5	4	4	5	5	5	5	5	4	4	4	4	3	3	4	3	2.0	3.0	2.0	2.0	3.0	3.0	2.0	7.0	8.0	5.0	3.0	2.0	2.0	3.0	0.0	2.0	0.0	4.0	0.0	0.0	0.0	5.0	5.0

	Gender of respondent	How old are you?	Which city do you shop online from?	Since How Long You are Shopping Online ?	How many times you have made an online purchase in the past year?	How do you access the internet while shopping on-line?	Which device do you use to access the online shopping?	What is the screen size of your mobile device?	What is the operating system (OS) of your device?	What browser do you run on your device to access the website?	Which channel did you follow to arrive at your favorite online store for the first time?	After first visit, how do you reach the online retail store?	How much time do you explore the e- retail store before making a purchase decision?	What is your preferred payment Option?	How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart?	Why did you abandon the “Bag”, “Shopping Cart”?	The content on the website must be easy to read and understand	Information on similar product to the one highlighted is important for product comparison	Complete information on listed seller and product being offered is important for purchase decision.	All relevant information on listed products must be stated clearly	Ease of navigation in website	Loading and processing speed	User friendly Interface of the website	Convenient Payment methods	Trust that the online retail store will fulfill its part of the transaction at the stipulated time	Empathy (readiness to assist with queries) towards the customers	Being able to guarantee the privacy of the customer	Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.)	Online shopping gives monetary benefit and discounts	Enjoyment is derived from shopping online	Shopping online is convenient and flexible	Return and replacement policy of the e-tailer is important for purchase decision	Gaining access to loyalty programs is a benefit of shopping online	Displaying quality Information on the website improves satisfaction of customers	User derive satisfaction while shopping on a good quality website or application	Net Benefit derived from shopping online can lead to users satisfaction	User satisfaction cannot exist without trust	Offering a wide variety of listed product in several category	Provision of complete and relevant product information	Monetary savings	The Convenience of patronizing the online retailer	Shopping on the website gives you the sense of adventure	Shopping on your preferred e-tailer enhances your social status	You feel gratification shopping on your favorite e-tailer	Shopping on the website helps you fulfill certain roles	Getting value for money spent	From the following, tick any (or all) of the online retailers you have shopped from;	Easy to use website or application	Visual appealing web-page layout	Wild variety of product on offer	Complete, relevant description information of products	Fast loading website speed of website and application	Reliability of the website or application	Quickness to complete purchase	Availability of several payment options	Speedy order delivery	Privacy of customers’ information	Security of customer financial information	Perceived Trustworthiness	Presence of online assistance through multi-channel	Longer time to get logged in (promotion, sales period)	Longer time in displaying graphics and photos (promotion, sales period)	Late declaration of price (promotion, sales period)	Longer page loading time (promotion, sales period)	Limited mode of payment on most products (promotion, sales period)	Longer delivery period	Change in website/Application design	Frequent disruption when moving from one page to another	Website is as efficient as before
0	0	1.0	2.0	3.0	2.0	0.0	0.0	3.0	2.0	0.0	2.0	2.0	2.0	2.0	2.0	2.0	4	3	3	4	4	1	2	2	2	5	4	4	3	1	2	2	4	3	5	4	5	3	3	2	3	4	4	5	4	5	7.0	9.0	7.0	5.0	10.0	9.0	9.0	8.0	9.0	0.0	0.0	0.0	7.0	9.0	0.0	0.0	3.0	5.0	0.0	3.0	2.0	0.0	0.0
1	1	0.0	2.0	3.0	3.0	2.0	2.0	0.0	1.0	0.0	2.0	4.0	4.0	1.0	3.0	4.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	3	5	5	5	2.0	3.0	5.0	6.0	2.0	2.0	8.0	2.0	2.0	1.0	9.0	9.0	8.0	2.0	1.0	6.0	7.0	10.0	7.0	5.0	0.0	4.0	1.0
2	1	0.0	8.0	2.0	3.0	1.0	2.0	2.0	0.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
3	0	0.0	5.0	2.0	4.0	1.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
4	1	0.0	0.0	1.0	0.0	2.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
5	1	1.0	8.0	3.0	3.0	2.0	2.0	2.0	0.0	0.0	2.0	4.0	4.0	2.0	0.0	0.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	4	5	4.0	4.0	1.0	3.0	4.0	7.0	4.0	8.0	4.0	0.0	5.0	4.0	4.0	4.0	6.0	3.0	2.0	2.0	2.0	1.0	5.0	2.0	0.0
6	0	2.0	2.0	3.0	2.0	2.0	3.0	3.0	0.0	0.0	1.0	0.0	4.0	1.0	2.0	4.0	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	5	5	4	4	4	4	4	3	4	4	3	3	4	4	4	5.0	5.0	3.0	0.0	9.0	5.0	5.0	3.0	5.0	3.0	5.0	4.0	5.0	3.0	2.0	0.0	4.0	7.0	3.0	5.0	4.0	4.0	7.0
7	0	2.0	2.0	2.0	4.0	1.0	0.0	3.0	2.0	0.0	2.0	1.0	2.0	1.0	2.0	1.0	1	2	2	1	1	2	1	2	2	1	3	5	1	1	5	5	5	5	5	4	1	5	5	5	5	5	1	1	1	4	4.0	1.0	1.0	1.0	1.0	4.0	0.0	0.0	1.0	0.0	10.0	8.0	0.0	0.0	1.0	1.0	5.0	1.0	1.0	1.0	0.0	0.0	0.0
8	1	4.0	9.0	1.0	4.0	2.0	2.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	3.0	5	4	5	4	4	4	5	5	5	5	5	5	5	4	5	4	4	5	5	5	5	5	4	4	4	4	3	3	4	3	2.0	3.0	2.0	2.0	3.0	3.0	2.0	7.0	8.0	5.0	3.0	2.0	2.0	3.0	0.0	2.0	0.0	4.0	0.0	0.0	0.0	5.0	5.0
9	1	1.0	2.0	4.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	2.0	4.0	0.0	2.0	2.0	4	5	4	4	5	5	5	4	5	5	5	5	4	4	4	5	4	4	4	5	4	4	4	4	4	4	3	3	3	4	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	8.0	1.0	5.0	8.0	7.0	5.0	4.0	4.0	4.0
10	0	1.0	7.0	3.0	1.0	1.0	1.0	3.0	2.0	0.0	2.0	0.0	2.0	1.0	2.0	1.0	5	3	4	5	4	5	4	4	5	4	5	4	2	3	4	5	1	3	4	2	5	3	4	2	3	4	2	2	4	3	5.0	5.0	4.0	1.0	4.0	7.0	3.0	3.0	6.0	1.0	4.0	3.0	3.0	0.0	3.0	1.0	3.0	6.0	1.0	4.0	0.0	3.0	3.0
11	1	2.0	8.0	3.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	4	5	5	4	5	4	4	5	5	5	3	2	5	5	4	5	5	5	4	3	5	5	3	2	4	4	3	4	6.0	2.0	1.0	1.0	0.0	5.0	0.0	0.0	3.0	1.0	1.0	7.0	0.0	6.0	8.0	5.0	4.0	7.0	7.0	2.0	5.0	6.0	1.0
12	1	3.0	4.0	1.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	5	5	5	5	5	5	5	5	5	3	4	4	4	5	5	5	5	5	5	5	5	3	4	2	3	3	2	4	2.0	3.0	8.0	1.0	1.0	2.0	1.0	2.0	1.0	2.0	0.0	0.0	0.0	1.0	7.0	9.0	7.0	9.0	6.0	4.0	1.0	7.0	4.0
13	1	1.0	8.0	3.0	0.0	2.0	1.0	3.0	2.0	0.0	2.0	2.0	1.0	1.0	2.0	0.0	5	5	1	5	5	5	5	5	5	5	5	1	3	3	5	5	3	5	5	5	5	4	5	4	4	3	2	2	4	5	4.0	4.0	1.0	1.0	1.0	1.0	1.0	1.0	4.0	1.0	1.0	4.0	2.0	3.0	2.0	9.0	7.0	7.0	7.0	5.0	5.0	7.0	1.0
14	1	0.0	5.0	4.0	3.0	2.0	2.0	2.0	0.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
15	1	0.0	0.0	1.0	3.0	1.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
16	0	1.0	8.0	0.0	1.0	1.0	1.0	3.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
17	0	2.0	2.0	4.0	4.0	2.0	1.0	3.0	2.0	0.0	2.0	4.0	4.0	2.0	0.0	0.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	4	5	4.0	4.0	1.0	3.0	4.0	7.0	4.0	8.0	4.0	0.0	5.0	4.0	4.0	4.0	6.0	3.0	2.0	2.0	2.0	1.0	5.0	2.0	0.0
18	1	2.0	2.0	0.0	4.0	2.0	1.0	3.0	2.0	0.0	1.0	0.0	4.0	1.0	2.0	4.0	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	5	5	4	4	4	4	4	3	4	4	3	3	4	4	4	5.0	5.0	3.0	0.0	9.0	5.0	5.0	3.0	5.0	3.0	5.0	4.0	5.0	3.0	2.0	0.0	4.0	7.0	3.0	5.0	4.0	4.0	7.0
19	1	0.0	9.0	0.0	0.0	2.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
20	1	0.0	8.0	0.0	3.0	2.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
21	0	1.0	4.0	2.0	2.0	2.0	3.0	1.0	0.0	0.0	2.0	1.0	2.0	1.0	2.0	1.0	1	2	2	1	1	2	1	2	2	1	3	5	1	1	5	5	5	5	5	4	1	5	5	5	5	5	1	1	1	4	4.0	1.0	1.0	1.0	1.0	4.0	0.0	0.0	1.0	0.0	10.0	8.0	0.0	0.0	1.0	1.0	5.0	1.0	1.0	1.0	0.0	0.0	0.0
22	0	2.0	8.0	3.0	2.0	1.0	3.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	3.0	5	4	5	4	4	4	5	5	5	5	5	5	5	4	5	4	4	5	5	5	5	5	4	4	4	4	3	3	4	3	2.0	3.0	2.0	2.0	3.0	3.0	2.0	7.0	8.0	5.0	3.0	2.0	2.0	3.0	0.0	2.0	0.0	4.0	0.0	0.0	0.0	5.0	5.0
23	1	2.0	8.0	3.0	3.0	1.0	0.0	3.0	2.0	0.0	2.0	2.0	4.0	0.0	2.0	2.0	4	5	4	4	5	5	5	4	5	5	5	5	4	4	4	5	4	4	4	5	4	4	4	4	4	4	3	3	3	4	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	1.0	8.0	1.0	5.0	8.0	7.0	5.0	4.0	4.0	4.0
24	1	0.0	6.0	2.0	3.0	1.0	2.0	1.0	2.0	0.0	2.0	0.0	2.0	1.0	2.0	1.0	5	3	4	5	4	5	4	4	5	4	5	4	2	3	4	5	1	3	4	2	5	3	4	2	3	4	2	2	4	3	5.0	5.0	4.0	1.0	4.0	7.0	3.0	3.0	6.0	1.0	4.0	3.0	3.0	0.0	3.0	1.0	3.0	6.0	1.0	4.0	0.0	3.0	3.0
25	1	0.0	0.0	1.0	4.0	1.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	4	5	5	4	5	4	4	5	5	5	3	2	5	5	4	5	5	5	4	3	5	5	3	2	4	4	3	4	6.0	2.0	1.0	1.0	0.0	5.0	0.0	0.0	3.0	1.0	1.0	7.0	0.0	6.0	8.0	5.0	4.0	7.0	7.0	2.0	5.0	6.0	1.0
26	0	0.0	3.0	4.0	0.0	1.0	1.0	3.0	2.0	0.0	2.0	0.0	4.0	1.0	2.0	0.0	5	5	5	5	5	5	5	5	5	5	5	3	4	4	4	5	5	5	5	5	5	5	5	3	4	2	3	3	2	4	2.0	3.0	8.0	1.0	1.0	2.0	1.0	2.0	1.0	2.0	0.0	0.0	0.0	1.0	7.0	9.0	7.0	9.0	6.0	4.0	1.0	7.0	4.0
27	0	1.0	2.0	3.0	3.0	1.0	1.0	3.0	2.0	0.0	2.0	2.0	1.0	1.0	2.0	0.0	5	5	1	5	5	5	5	5	5	5	5	1	3	3	5	5	3	5	5	5	5	4	5	4	4	3	2	2	4	5	4.0	4.0	1.0	1.0	1.0	1.0	1.0	1.0	4.0	1.0	1.0	4.0	2.0	3.0	2.0	9.0	7.0	7.0	7.0	5.0	5.0	7.0	1.0
28	1	2.0	8.0	3.0	2.0	1.0	1.0	3.0	2.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
29	1	2.0	5.0	1.0	4.0	1.0	1.0	3.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
30	1	4.0	0.0	3.0	4.0	1.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
31	0	1.0	8.0	1.0	4.0	1.0	0.0	3.0	2.0	0.0	2.0	2.0	2.0	2.0	2.0	2.0	4	3	3	4	4	1	2	2	2	5	4	4	3	1	2	2	4	3	5	4	5	3	3	2	3	4	4	5	4	5	7.0	9.0	7.0	5.0	10.0	9.0	9.0	8.0	9.0	0.0	0.0	0.0	7.0	9.0	0.0	0.0	3.0	5.0	0.0	3.0	2.0	0.0	0.0
32	0	1.0	2.0	3.0	1.0	1.0	2.0	0.0	1.0	0.0	2.0	4.0	4.0	1.0	3.0	4.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	3	5	5	5	2.0	3.0	5.0	6.0	2.0	2.0	8.0	2.0	2.0	1.0	9.0	9.0	8.0	2.0	1.0	6.0	7.0	10.0	7.0	5.0	0.0	4.0	1.0
33	1	2.0	8.0	3.0	4.0	1.0	2.0	2.0	0.0	0.0	2.0	4.0	1.0	2.0	2.0	4.0	5	4	4	4	4	4	5	5	5	5	5	5	5	5	5	5	5	5	5	5	4	5	5	5	4	4	4	3	3	4	8.0	7.0	6.0	4.0	7.0	7.0	6.0	5.0	10.0	0.0	0.0	6.0	6.0	8.0	7.0	6.0	4.0	7.0	0.0	3.0	5.0	6.0	0.0
34	1	3.0	5.0	2.0	4.0	1.0	2.0	2.0	1.0	3.0	2.0	2.0	2.0	1.0	1.0	0.0	4	4	3	4	5	4	5	5	4	5	5	4	4	3	3	4	3	3	4	3	4	4	4	5	4	4	5	4	3	4	4.0	4.0	3.0	1.0	1.0	6.0	3.0	3.0	2.0	3.0	2.0	5.0	5.0	3.0	9.0	7.0	4.0	8.0	5.0	3.0	1.0	1.0	2.0
35	1	0.0	0.0	1.0	0.0	1.0	2.0	0.0	1.0	3.0	0.0	4.0	4.0	1.0	0.0	0.0	5	3	3	4	4	5	5	5	4	5	4	5	5	5	5	5	2	4	5	5	5	4	4	5	4	3	1	5	1	5	4.0	4.0	9.0	7.0	5.0	0.0	6.0	4.0	4.0	0.0	7.0	10.0	6.0	5.0	5.0	8.0	5.0	8.0	7.0	3.0	0.0	7.0	6.0
36	0	1.0	8.0	4.0	4.0	1.0	2.0	2.0	0.0	0.0	2.0	4.0	4.0	2.0	0.0	0.0	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	5	3	3	4	5	4.0	4.0	1.0	3.0	4.0	7.0	4.0	8.0	4.0	0.0	5.0	4.0	4.0	4.0	6.0	3.0	2.0	2.0	2.0	1.0	5.0	2.0	0.0
37	0	2.0	2.0	3.0	0.0	1.0	3.0	3.0	0.0	0.0	1.0	0.0	4.0	1.0	2.0	4.0	4	4	4	4	4	4	4	4	4	4	4	4	4	4	4	5	5	4	4	4	4	4	3	4	4	3	3	4	4	4	5.0	5.0	3.0	0.0	9.0	5.0	5.0	3.0	5.0	3.0	5.0	4.0	5.0	3.0	2.0	0.0	4.0	7.0	3.0	5.0	4.0	4.0	7.0
38	1	2.0	8.0	3.0	3.0	1.0	0.0	3.0	2.0	0.0	2.0	1.0	2.0	1.0	2.0	1.0	1	2	2	1	1	2	1	2	2	1	3	5	1	1	5	5	5	5	5	4	1	5	5	5	5	5	1	1	1	4	4.0	1.0	1.0	1.0	1.0	4.0	0.0	0.0	1.0	0.0	10.0	8.0	0.0	0.0	1.0	1.0	5.0	1.0	1.0	1.0	0.0	0.0	0.0
39	1	0.0	5.0	1.0	2.0	1.0	2.0	2.0	0.0	0.0	2.0	0.0	0.0	0.0	2.0	3.0	5	4	5	4	4	4	5	5	5	5	5	5	5	4	5	4	4	5	5	5	5	5	4	4	4	4	3	3	4	3	2.0	3.0	2.0	2.0	3.0	3.0	2.0	7.0	8.0	5.0	3.0	2.0	2.0	3.0	0.0	2.0	0.0	4.0	0.0	0.0	0.0	5.0	5.0

	Gender of respondent	How old are you?	Which city do you shop online from?	Since How Long You are Shopping Online ?	How many times you have made an online purchase in the past year?	How do you access the internet while shopping on-line?	Which device do you use to access the online shopping?	What is the screen size of your mobile device?	What is the operating system (OS) of your device?	What browser do you run on your device to access the website?	Which channel did you follow to arrive at your favorite online store for the first time?	After first visit, how do you reach the online retail store?	How much time do you explore the e- retail store before making a purchase decision?	What is your preferred payment Option?	How frequently do you abandon (selecting an items and leaving without making payment) your shopping cart?	Why did you abandon the “Bag”, “Shopping Cart”?	The content on the website must be easy to read and understand	Information on similar product to the one highlighted is important for product comparison	Complete information on listed seller and product being offered is important for purchase decision.	All relevant information on listed products must be stated clearly	Ease of navigation in website	Loading and processing speed	User friendly Interface of the website	Convenient Payment methods	Trust that the online retail store will fulfill its part of the transaction at the stipulated time	Empathy (readiness to assist with queries) towards the customers	Being able to guarantee the privacy of the customer	Responsiveness, availability of several communication channels (email, online rep, twitter, phone etc.)	Online shopping gives monetary benefit and discounts	Enjoyment is derived from shopping online	Shopping online is convenient and flexible	Return and replacement policy of the e-tailer is important for purchase decision	Gaining access to loyalty programs is a benefit of shopping online	Displaying quality Information on the website improves satisfaction of customers	User derive satisfaction while shopping on a good quality website or application	Net Benefit derived from shopping online can lead to users satisfaction	User satisfaction cannot exist without trust	Offering a wide variety of listed product in several category	Provision of complete and relevant product information	Monetary savings	The Convenience of patronizing the online retailer	Shopping on the website gives you the sense of adventure	Shopping on your preferred e-tailer enhances your social status	You feel gratification shopping on your favorite e-tailer	Shopping on the website helps you fulfill certain roles	Getting value for money spent	From the following, tick any (or all) of the online retailers you have shopped from;	Easy to use website or application	Visual appealing web-page layout	Wild variety of product on offer	Complete, relevant description information of products	Fast loading website speed of website and application	Reliability of the website or application	Quickness to complete purchase	Availability of several payment options	Speedy order delivery	Privacy of customers’ information	Security of customer financial information	Perceived Trustworthiness	Presence of online assistance through multi-channel	Longer time to get logged in (promotion, sales period)	Longer time in displaying graphics and photos (promotion, sales period)	Late declaration of price (promotion, sales period)	Longer page loading time (promotion, sales period)	Limited mode of payment on most products (promotion, sales period)	Longer delivery period	Change in website/Application design	Frequent disruption when moving from one page to another	Website is as efficient as before
0	0.0	0.25	0.222222	0.75	0.50	0.0	0.000000	1.000000	1.0	0.000000	1.0	0.50	0.50	1.0	0.666667	0.50	0.75	0.333333	0.50	0.75	0.75	0.00	0.25	0.000000	0.000000	1.00	0.5	0.75	0.50	0.00	0.000000	0.000000	0.75	0.0	1.000000	0.666667	1.00	0.333333	0.333333	0.000000	0.0	0.75	0.75	1.00	0.75	1.0	0.875	1.000000	0.777778	0.625	1.0	1.000000	1.000000	1.000	0.9	0.0	0.0	0.0	0.875	1.000000	0.000000	0.000000	0.428571	0.5	0.000000	0.6	0.333333	0.000000	0.000000
1	1.0	0.00	0.222222	0.75	0.75	1.0	0.666667	0.000000	0.5	0.000000	1.0	1.00	1.00	0.5	1.000000	1.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	1.000000	0.0	0.50	0.50	1.00	1.00	1.0	0.250	0.333333	0.555556	0.750	0.2	0.222222	0.888889	0.250	0.2	0.2	0.9	0.9	1.000	0.222222	0.111111	0.666667	1.000000	1.0	1.000000	1.0	0.000000	0.571429	0.142857
2	1.0	0.00	0.888889	0.50	0.75	0.5	0.666667	0.666667	0.0	0.000000	1.0	1.00	0.25	1.0	0.666667	1.00	1.00	0.666667	0.75	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	0.75	1.000000	1.000000	1.000000	0.5	0.75	0.75	0.50	0.50	0.5	1.000	0.777778	0.666667	0.500	0.7	0.777778	0.666667	0.625	1.0	0.0	0.0	0.6	0.750	0.888889	0.777778	0.666667	0.571429	0.7	0.000000	0.6	0.833333	0.857143	0.000000
3	0.0	0.00	0.555556	0.50	1.00	0.5	0.666667	0.666667	0.5	1.000000	1.0	0.50	0.50	0.5	0.333333	0.00	0.75	0.666667	0.50	0.75	1.00	0.75	1.00	1.000000	0.666667	1.00	1.0	0.75	0.75	0.50	0.333333	0.666667	0.50	0.0	0.666667	0.333333	0.75	0.666667	0.666667	1.000000	0.5	0.75	1.00	0.75	0.50	0.5	0.500	0.444444	0.333333	0.125	0.1	0.666667	0.333333	0.375	0.2	0.6	0.2	0.5	0.625	0.333333	1.000000	0.777778	0.571429	0.8	0.714286	0.6	0.166667	0.142857	0.285714
4	1.0	0.00	0.000000	0.25	0.00	1.0	0.666667	0.000000	0.5	1.000000	0.0	1.00	1.00	0.5	0.000000	0.00	1.00	0.333333	0.50	0.75	0.75	1.00	1.00	1.000000	0.666667	1.00	0.5	1.00	1.00	1.00	1.000000	1.000000	0.25	0.5	1.000000	1.000000	1.00	0.666667	0.666667	1.000000	0.5	0.50	0.00	1.00	0.00	1.0	0.500	0.444444	1.000000	0.875	0.5	0.000000	0.666667	0.500	0.4	0.0	0.7	1.0	0.750	0.555556	0.555556	0.888889	0.714286	0.8	1.000000	0.6	0.000000	1.000000	0.857143
5	1.0	0.25	0.888889	0.75	0.75	1.0	0.666667	0.666667	0.0	0.000000	1.0	1.00	1.00	1.0	0.000000	0.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	1.000000	1.0	1.00	0.50	0.50	0.75	1.0	0.500	0.444444	0.111111	0.375	0.4	0.777778	0.444444	1.000	0.4	0.0	0.5	0.4	0.500	0.444444	0.666667	0.333333	0.285714	0.2	0.285714	0.2	0.833333	0.285714	0.000000
6	0.0	0.50	0.222222	0.75	0.50	1.0	1.000000	1.000000	0.0	0.000000	0.5	0.00	1.00	0.5	0.666667	1.00	0.75	0.666667	0.75	0.75	0.75	0.75	0.75	0.666667	0.666667	0.75	0.5	0.75	0.75	0.75	0.666667	1.000000	1.00	0.5	0.666667	0.666667	0.75	0.666667	0.333333	0.666667	0.5	0.50	0.50	0.75	0.75	0.5	0.625	0.555556	0.333333	0.000	0.9	0.555556	0.555556	0.375	0.5	0.6	0.5	0.4	0.625	0.333333	0.222222	0.000000	0.571429	0.7	0.428571	1.0	0.666667	0.571429	1.000000
7	0.0	0.50	0.222222	0.50	1.00	0.5	0.000000	1.000000	1.0	0.000000	1.0	0.25	0.50	0.5	0.666667	0.25	0.00	0.000000	0.25	0.00	0.00	0.25	0.00	0.000000	0.000000	0.00	0.0	1.00	0.00	0.00	1.000000	1.000000	1.00	1.0	1.000000	0.666667	0.00	1.000000	1.000000	1.000000	1.0	1.00	0.00	0.00	0.00	0.5	0.500	0.111111	0.111111	0.125	0.1	0.444444	0.000000	0.000	0.1	0.0	1.0	0.8	0.000	0.000000	0.111111	0.111111	0.714286	0.1	0.142857	0.2	0.000000	0.000000	0.000000
8	1.0	1.00	1.000000	0.25	1.00	1.0	0.666667	0.666667	0.0	0.000000	1.0	0.00	0.00	0.0	0.666667	0.75	1.00	0.666667	1.00	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	0.75	1.000000	0.666667	0.75	1.0	1.000000	1.000000	1.00	1.000000	0.666667	0.666667	0.5	0.75	0.50	0.50	0.75	0.0	0.250	0.333333	0.222222	0.250	0.3	0.333333	0.222222	0.875	0.8	1.0	0.3	0.2	0.250	0.333333	0.000000	0.222222	0.000000	0.4	0.000000	0.0	0.000000	0.714286	0.714286
9	1.0	0.25	0.222222	1.00	1.00	1.0	0.333333	1.000000	1.0	0.000000	1.0	0.50	1.00	0.0	0.666667	0.50	0.75	1.000000	0.75	0.75	1.00	1.00	1.00	0.666667	1.000000	1.00	1.0	1.00	0.75	0.75	0.666667	1.000000	0.75	0.5	0.666667	1.000000	0.75	0.666667	0.666667	0.666667	0.5	0.75	0.50	0.50	0.50	0.5	0.125	0.111111	0.111111	0.125	0.1	0.111111	0.111111	0.125	0.1	0.2	0.1	0.1	0.125	0.111111	0.888889	0.111111	0.714286	0.8	1.000000	1.0	0.666667	0.571429	0.571429
10	0.0	0.25	0.777778	0.75	0.25	0.5	0.333333	1.000000	1.0	0.000000	1.0	0.00	0.50	0.5	0.666667	0.25	1.00	0.333333	0.75	1.00	0.75	1.00	0.75	0.666667	1.000000	0.75	1.0	0.75	0.25	0.50	0.666667	1.000000	0.00	0.0	0.666667	0.000000	1.00	0.333333	0.666667	0.000000	0.0	0.75	0.25	0.25	0.75	0.0	0.625	0.555556	0.444444	0.125	0.4	0.777778	0.333333	0.375	0.6	0.2	0.4	0.3	0.375	0.000000	0.333333	0.111111	0.428571	0.6	0.142857	0.8	0.000000	0.428571	0.428571
11	1.0	0.50	0.888889	0.75	1.00	1.0	0.333333	1.000000	1.0	0.000000	1.0	0.00	1.00	0.5	0.666667	0.00	1.00	1.000000	0.75	1.00	1.00	0.75	1.00	0.666667	0.666667	1.00	1.0	1.00	0.50	0.25	1.000000	1.000000	0.75	1.0	1.000000	1.000000	0.75	0.333333	1.000000	1.000000	0.0	0.25	0.75	0.75	0.50	0.5	0.750	0.222222	0.111111	0.125	0.0	0.555556	0.000000	0.000	0.3	0.2	0.1	0.7	0.000	0.666667	0.888889	0.555556	0.571429	0.7	1.000000	0.4	0.833333	0.857143	0.142857
12	1.0	0.75	0.444444	0.25	1.00	1.0	0.333333	1.000000	1.0	0.000000	1.0	0.00	1.00	0.5	0.666667	0.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	0.50	0.75	0.75	0.666667	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	0.333333	0.5	0.25	0.50	0.50	0.25	0.5	0.250	0.333333	0.888889	0.125	0.1	0.222222	0.111111	0.250	0.1	0.4	0.0	0.0	0.000	0.111111	0.777778	1.000000	1.000000	0.9	0.857143	0.8	0.166667	1.000000	0.571429
13	1.0	0.25	0.888889	0.75	0.00	1.0	0.333333	1.000000	1.0	0.000000	1.0	0.50	0.25	0.5	0.666667	0.00	1.00	1.000000	0.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	0.00	0.50	0.50	1.000000	1.000000	0.50	1.0	1.000000	1.000000	1.00	0.666667	1.000000	0.666667	0.5	0.50	0.25	0.25	0.75	1.0	0.500	0.444444	0.111111	0.125	0.1	0.111111	0.111111	0.125	0.4	0.2	0.1	0.4	0.250	0.333333	0.222222	1.000000	1.000000	0.7	1.000000	1.0	0.833333	1.000000	0.142857
14	1.0	0.00	0.555556	1.00	0.75	1.0	0.666667	0.666667	0.0	0.000000	1.0	1.00	0.25	1.0	0.666667	1.00	1.00	0.666667	0.75	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	0.75	1.000000	1.000000	1.000000	0.5	0.75	0.75	0.50	0.50	0.5	1.000	0.777778	0.666667	0.500	0.7	0.777778	0.666667	0.625	1.0	0.0	0.0	0.6	0.750	0.888889	0.777778	0.666667	0.571429	0.7	0.000000	0.6	0.833333	0.857143	0.000000
15	1.0	0.00	0.000000	0.25	0.75	0.5	0.666667	0.666667	0.5	1.000000	1.0	0.50	0.50	0.5	0.333333	0.00	0.75	0.666667	0.50	0.75	1.00	0.75	1.00	1.000000	0.666667	1.00	1.0	0.75	0.75	0.50	0.333333	0.666667	0.50	0.0	0.666667	0.333333	0.75	0.666667	0.666667	1.000000	0.5	0.75	1.00	0.75	0.50	0.5	0.500	0.444444	0.333333	0.125	0.1	0.666667	0.333333	0.375	0.2	0.6	0.2	0.5	0.625	0.333333	1.000000	0.777778	0.571429	0.8	0.714286	0.6	0.166667	0.142857	0.285714
16	0.0	0.25	0.888889	0.00	0.25	0.5	0.333333	1.000000	0.5	1.000000	0.0	1.00	1.00	0.5	0.000000	0.00	1.00	0.333333	0.50	0.75	0.75	1.00	1.00	1.000000	0.666667	1.00	0.5	1.00	1.00	1.00	1.000000	1.000000	0.25	0.5	1.000000	1.000000	1.00	0.666667	0.666667	1.000000	0.5	0.50	0.00	1.00	0.00	1.0	0.500	0.444444	1.000000	0.875	0.5	0.000000	0.666667	0.500	0.4	0.0	0.7	1.0	0.750	0.555556	0.555556	0.888889	0.714286	0.8	1.000000	0.6	0.000000	1.000000	0.857143
17	0.0	0.50	0.222222	1.00	1.00	1.0	0.333333	1.000000	1.0	0.000000	1.0	1.00	1.00	1.0	0.000000	0.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	1.000000	1.0	1.00	0.50	0.50	0.75	1.0	0.500	0.444444	0.111111	0.375	0.4	0.777778	0.444444	1.000	0.4	0.0	0.5	0.4	0.500	0.444444	0.666667	0.333333	0.285714	0.2	0.285714	0.2	0.833333	0.285714	0.000000
18	1.0	0.50	0.222222	0.00	1.00	1.0	0.333333	1.000000	1.0	0.000000	0.5	0.00	1.00	0.5	0.666667	1.00	0.75	0.666667	0.75	0.75	0.75	0.75	0.75	0.666667	0.666667	0.75	0.5	0.75	0.75	0.75	0.666667	1.000000	1.00	0.5	0.666667	0.666667	0.75	0.666667	0.333333	0.666667	0.5	0.50	0.50	0.75	0.75	0.5	0.625	0.555556	0.333333	0.000	0.9	0.555556	0.555556	0.375	0.5	0.6	0.5	0.4	0.625	0.333333	0.222222	0.000000	0.571429	0.7	0.428571	1.0	0.666667	0.571429	1.000000
19	1.0	0.00	1.000000	0.00	0.00	1.0	0.666667	0.666667	0.5	1.000000	1.0	0.50	0.50	0.5	0.333333	0.00	0.75	0.666667	0.50	0.75	1.00	0.75	1.00	1.000000	0.666667	1.00	1.0	0.75	0.75	0.50	0.333333	0.666667	0.50	0.0	0.666667	0.333333	0.75	0.666667	0.666667	1.000000	0.5	0.75	1.00	0.75	0.50	0.5	0.500	0.444444	0.333333	0.125	0.1	0.666667	0.333333	0.375	0.2	0.6	0.2	0.5	0.625	0.333333	1.000000	0.777778	0.571429	0.8	0.714286	0.6	0.166667	0.142857	0.285714
20	1.0	0.00	0.888889	0.00	0.75	1.0	0.666667	0.000000	0.5	1.000000	0.0	1.00	1.00	0.5	0.000000	0.00	1.00	0.333333	0.50	0.75	0.75	1.00	1.00	1.000000	0.666667	1.00	0.5	1.00	1.00	1.00	1.000000	1.000000	0.25	0.5	1.000000	1.000000	1.00	0.666667	0.666667	1.000000	0.5	0.50	0.00	1.00	0.00	1.0	0.500	0.444444	1.000000	0.875	0.5	0.000000	0.666667	0.500	0.4	0.0	0.7	1.0	0.750	0.555556	0.555556	0.888889	0.714286	0.8	1.000000	0.6	0.000000	1.000000	0.857143
21	0.0	0.25	0.444444	0.50	0.50	1.0	1.000000	0.333333	0.0	0.000000	1.0	0.25	0.50	0.5	0.666667	0.25	0.00	0.000000	0.25	0.00	0.00	0.25	0.00	0.000000	0.000000	0.00	0.0	1.00	0.00	0.00	1.000000	1.000000	1.00	1.0	1.000000	0.666667	0.00	1.000000	1.000000	1.000000	1.0	1.00	0.00	0.00	0.00	0.5	0.500	0.111111	0.111111	0.125	0.1	0.444444	0.000000	0.000	0.1	0.0	1.0	0.8	0.000	0.000000	0.111111	0.111111	0.714286	0.1	0.142857	0.2	0.000000	0.000000	0.000000
22	0.0	0.50	0.888889	0.75	0.50	0.5	1.000000	0.666667	0.0	0.000000	1.0	0.00	0.00	0.0	0.666667	0.75	1.00	0.666667	1.00	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	0.75	1.000000	0.666667	0.75	1.0	1.000000	1.000000	1.00	1.000000	0.666667	0.666667	0.5	0.75	0.50	0.50	0.75	0.0	0.250	0.333333	0.222222	0.250	0.3	0.333333	0.222222	0.875	0.8	1.0	0.3	0.2	0.250	0.333333	0.000000	0.222222	0.000000	0.4	0.000000	0.0	0.000000	0.714286	0.714286
23	1.0	0.50	0.888889	0.75	0.75	0.5	0.000000	1.000000	1.0	0.000000	1.0	0.50	1.00	0.0	0.666667	0.50	0.75	1.000000	0.75	0.75	1.00	1.00	1.00	0.666667	1.000000	1.00	1.0	1.00	0.75	0.75	0.666667	1.000000	0.75	0.5	0.666667	1.000000	0.75	0.666667	0.666667	0.666667	0.5	0.75	0.50	0.50	0.50	0.5	0.125	0.111111	0.111111	0.125	0.1	0.111111	0.111111	0.125	0.1	0.2	0.1	0.1	0.125	0.111111	0.888889	0.111111	0.714286	0.8	1.000000	1.0	0.666667	0.571429	0.571429
24	1.0	0.00	0.666667	0.50	0.75	0.5	0.666667	0.333333	1.0	0.000000	1.0	0.00	0.50	0.5	0.666667	0.25	1.00	0.333333	0.75	1.00	0.75	1.00	0.75	0.666667	1.000000	0.75	1.0	0.75	0.25	0.50	0.666667	1.000000	0.00	0.0	0.666667	0.000000	1.00	0.333333	0.666667	0.000000	0.0	0.75	0.25	0.25	0.75	0.0	0.625	0.555556	0.444444	0.125	0.4	0.777778	0.333333	0.375	0.6	0.2	0.4	0.3	0.375	0.000000	0.333333	0.111111	0.428571	0.6	0.142857	0.8	0.000000	0.428571	0.428571
25	1.0	0.00	0.000000	0.25	1.00	0.5	0.333333	1.000000	1.0	0.000000	1.0	0.00	1.00	0.5	0.666667	0.00	1.00	1.000000	0.75	1.00	1.00	0.75	1.00	0.666667	0.666667	1.00	1.0	1.00	0.50	0.25	1.000000	1.000000	0.75	1.0	1.000000	1.000000	0.75	0.333333	1.000000	1.000000	0.0	0.25	0.75	0.75	0.50	0.5	0.750	0.222222	0.111111	0.125	0.0	0.555556	0.000000	0.000	0.3	0.2	0.1	0.7	0.000	0.666667	0.888889	0.555556	0.571429	0.7	1.000000	0.4	0.833333	0.857143	0.142857
26	0.0	0.00	0.333333	1.00	0.00	0.5	0.333333	1.000000	1.0	0.000000	1.0	0.00	1.00	0.5	0.666667	0.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	0.50	0.75	0.75	0.666667	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	0.333333	0.5	0.25	0.50	0.50	0.25	0.5	0.250	0.333333	0.888889	0.125	0.1	0.222222	0.111111	0.250	0.1	0.4	0.0	0.0	0.000	0.111111	0.777778	1.000000	1.000000	0.9	0.857143	0.8	0.166667	1.000000	0.571429
27	0.0	0.25	0.222222	0.75	0.75	0.5	0.333333	1.000000	1.0	0.000000	1.0	0.50	0.25	0.5	0.666667	0.00	1.00	1.000000	0.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	0.00	0.50	0.50	1.000000	1.000000	0.50	1.0	1.000000	1.000000	1.00	0.666667	1.000000	0.666667	0.5	0.50	0.25	0.25	0.75	1.0	0.500	0.444444	0.111111	0.125	0.1	0.111111	0.111111	0.125	0.4	0.2	0.1	0.4	0.250	0.333333	0.222222	1.000000	1.000000	0.7	1.000000	1.0	0.833333	1.000000	0.142857
28	1.0	0.50	0.888889	0.75	0.50	0.5	0.333333	1.000000	1.0	0.000000	1.0	1.00	0.25	1.0	0.666667	1.00	1.00	0.666667	0.75	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	0.75	1.000000	1.000000	1.000000	0.5	0.75	0.75	0.50	0.50	0.5	1.000	0.777778	0.666667	0.500	0.7	0.777778	0.666667	0.625	1.0	0.0	0.0	0.6	0.750	0.888889	0.777778	0.666667	0.571429	0.7	0.000000	0.6	0.833333	0.857143	0.000000
29	1.0	0.50	0.555556	0.25	1.00	0.5	0.333333	1.000000	0.5	1.000000	1.0	0.50	0.50	0.5	0.333333	0.00	0.75	0.666667	0.50	0.75	1.00	0.75	1.00	1.000000	0.666667	1.00	1.0	0.75	0.75	0.50	0.333333	0.666667	0.50	0.0	0.666667	0.333333	0.75	0.666667	0.666667	1.000000	0.5	0.75	1.00	0.75	0.50	0.5	0.500	0.444444	0.333333	0.125	0.1	0.666667	0.333333	0.375	0.2	0.6	0.2	0.5	0.625	0.333333	1.000000	0.777778	0.571429	0.8	0.714286	0.6	0.166667	0.142857	0.285714
30	1.0	1.00	0.000000	0.75	1.00	0.5	0.666667	0.000000	0.5	1.000000	0.0	1.00	1.00	0.5	0.000000	0.00	1.00	0.333333	0.50	0.75	0.75	1.00	1.00	1.000000	0.666667	1.00	0.5	1.00	1.00	1.00	1.000000	1.000000	0.25	0.5	1.000000	1.000000	1.00	0.666667	0.666667	1.000000	0.5	0.50	0.00	1.00	0.00	1.0	0.500	0.444444	1.000000	0.875	0.5	0.000000	0.666667	0.500	0.4	0.0	0.7	1.0	0.750	0.555556	0.555556	0.888889	0.714286	0.8	1.000000	0.6	0.000000	1.000000	0.857143
31	0.0	0.25	0.888889	0.25	1.00	0.5	0.000000	1.000000	1.0	0.000000	1.0	0.50	0.50	1.0	0.666667	0.50	0.75	0.333333	0.50	0.75	0.75	0.00	0.25	0.000000	0.000000	1.00	0.5	0.75	0.50	0.00	0.000000	0.000000	0.75	0.0	1.000000	0.666667	1.00	0.333333	0.333333	0.000000	0.0	0.75	0.75	1.00	0.75	1.0	0.875	1.000000	0.777778	0.625	1.0	1.000000	1.000000	1.000	0.9	0.0	0.0	0.0	0.875	1.000000	0.000000	0.000000	0.428571	0.5	0.000000	0.6	0.333333	0.000000	0.000000
32	0.0	0.25	0.222222	0.75	0.25	0.5	0.666667	0.000000	0.5	0.000000	1.0	1.00	1.00	0.5	1.000000	1.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	1.000000	0.0	0.50	0.50	1.00	1.00	1.0	0.250	0.333333	0.555556	0.750	0.2	0.222222	0.888889	0.250	0.2	0.2	0.9	0.9	1.000	0.222222	0.111111	0.666667	1.000000	1.0	1.000000	1.0	0.000000	0.571429	0.142857
33	1.0	0.50	0.888889	0.75	1.00	0.5	0.666667	0.666667	0.0	0.000000	1.0	1.00	0.25	1.0	0.666667	1.00	1.00	0.666667	0.75	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	0.75	1.000000	1.000000	1.000000	0.5	0.75	0.75	0.50	0.50	0.5	1.000	0.777778	0.666667	0.500	0.7	0.777778	0.666667	0.625	1.0	0.0	0.0	0.6	0.750	0.888889	0.777778	0.666667	0.571429	0.7	0.000000	0.6	0.833333	0.857143	0.000000
34	1.0	0.75	0.555556	0.50	1.00	0.5	0.666667	0.666667	0.5	1.000000	1.0	0.50	0.50	0.5	0.333333	0.00	0.75	0.666667	0.50	0.75	1.00	0.75	1.00	1.000000	0.666667	1.00	1.0	0.75	0.75	0.50	0.333333	0.666667	0.50	0.0	0.666667	0.333333	0.75	0.666667	0.666667	1.000000	0.5	0.75	1.00	0.75	0.50	0.5	0.500	0.444444	0.333333	0.125	0.1	0.666667	0.333333	0.375	0.2	0.6	0.2	0.5	0.625	0.333333	1.000000	0.777778	0.571429	0.8	0.714286	0.6	0.166667	0.142857	0.285714
35	1.0	0.00	0.000000	0.25	0.00	0.5	0.666667	0.000000	0.5	1.000000	0.0	1.00	1.00	0.5	0.000000	0.00	1.00	0.333333	0.50	0.75	0.75	1.00	1.00	1.000000	0.666667	1.00	0.5	1.00	1.00	1.00	1.000000	1.000000	0.25	0.5	1.000000	1.000000	1.00	0.666667	0.666667	1.000000	0.5	0.50	0.00	1.00	0.00	1.0	0.500	0.444444	1.000000	0.875	0.5	0.000000	0.666667	0.500	0.4	0.0	0.7	1.0	0.750	0.555556	0.555556	0.888889	0.714286	0.8	1.000000	0.6	0.000000	1.000000	0.857143
36	0.0	0.25	0.888889	1.00	1.00	0.5	0.666667	0.666667	0.0	0.000000	1.0	1.00	1.00	1.0	0.000000	0.00	1.00	1.000000	1.00	1.00	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	1.00	1.000000	1.000000	1.00	1.0	1.000000	1.000000	1.00	1.000000	1.000000	1.000000	1.0	1.00	0.50	0.50	0.75	1.0	0.500	0.444444	0.111111	0.375	0.4	0.777778	0.444444	1.000	0.4	0.0	0.5	0.4	0.500	0.444444	0.666667	0.333333	0.285714	0.2	0.285714	0.2	0.833333	0.285714	0.000000
37	0.0	0.50	0.222222	0.75	0.00	0.5	1.000000	1.000000	0.0	0.000000	0.5	0.00	1.00	0.5	0.666667	1.00	0.75	0.666667	0.75	0.75	0.75	0.75	0.75	0.666667	0.666667	0.75	0.5	0.75	0.75	0.75	0.666667	1.000000	1.00	0.5	0.666667	0.666667	0.75	0.666667	0.333333	0.666667	0.5	0.50	0.50	0.75	0.75	0.5	0.625	0.555556	0.333333	0.000	0.9	0.555556	0.555556	0.375	0.5	0.6	0.5	0.4	0.625	0.333333	0.222222	0.000000	0.571429	0.7	0.428571	1.0	0.666667	0.571429	1.000000
38	1.0	0.50	0.888889	0.75	0.75	0.5	0.000000	1.000000	1.0	0.000000	1.0	0.25	0.50	0.5	0.666667	0.25	0.00	0.000000	0.25	0.00	0.00	0.25	0.00	0.000000	0.000000	0.00	0.0	1.00	0.00	0.00	1.000000	1.000000	1.00	1.0	1.000000	0.666667	0.00	1.000000	1.000000	1.000000	1.0	1.00	0.00	0.00	0.00	0.5	0.500	0.111111	0.111111	0.125	0.1	0.444444	0.000000	0.000	0.1	0.0	1.0	0.8	0.000	0.000000	0.111111	0.111111	0.714286	0.1	0.142857	0.2	0.000000	0.000000	0.000000
39	1.0	0.00	0.555556	0.25	0.50	0.5	0.666667	0.666667	0.0	0.000000	1.0	0.00	0.00	0.0	0.666667	0.75	1.00	0.666667	1.00	0.75	0.75	0.75	1.00	1.000000	1.000000	1.00	1.0	1.00	1.00	0.75	1.000000	0.666667	0.75	1.0	1.000000	1.000000	1.00	1.000000	0.666667	0.666667	0.5	0.75	0.50	0.50	0.75	0.0	0.250	0.333333	0.222222	0.250	0.3	0.333333	0.222222	0.875	0.8	1.0	0.3	0.2	0.250	0.333333	0.000000	0.222222	0.000000	0.4	0.000000	0.0	0.000000	0.714286	0.714286